From 46bab72af54c57cc654ebc0af685eafa3011c5dc Mon Sep 17 00:00:00 2001
From: Jinnaix <Jinnaix@users.noreply.github.com>
Date: Sun, 20 Jun 2021 17:32:19 +0200
Subject: DB/Misc: Add new View for RBAC

---
 sql/updates/auth/3.3.5/2021_06_20_00_auth.sql | 13 +++++++++++++
 1 file changed, 13 insertions(+)
 create mode 100644 sql/updates/auth/3.3.5/2021_06_20_00_auth.sql

(limited to 'sql')

diff --git a/sql/updates/auth/3.3.5/2021_06_20_00_auth.sql b/sql/updates/auth/3.3.5/2021_06_20_00_auth.sql
new file mode 100644
index 00000000000..4b8209a2123
--- /dev/null
+++ b/sql/updates/auth/3.3.5/2021_06_20_00_auth.sql
@@ -0,0 +1,13 @@
+--
+DROP VIEW IF EXISTS `vw_rbac`;
+
+CREATE SQL SECURITY INVOKER VIEW `vw_rbac` AS
+(
+    SELECT `t1`.`linkedId` AS `Permission ID`,
+           `t1`.`id` AS `Permission Group`,
+           IFNULL(`t2`.`secId`, 'linked') AS `Security Level`,
+       `t3`.`name` AS `Permission`
+    FROM `rbac_linked_permissions` `t1`
+    LEFT JOIN `rbac_default_permissions` `t2` ON `t1`.`id` = `t2`.`permissionId`
+    LEFT JOIN `rbac_permissions` `t3` ON `t1`.`linkedId` = `t3`.`id`
+);
-- 
cgit v1.2.3