aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/auth
diff options
context:
space:
mode:
authorTreeston <treeston.mmoc@gmail.com>2018-09-06 10:46:28 +0200
committerShauren <shauren.trinity@gmail.com>2021-10-23 22:31:27 +0200
commitf1ecb976ec9db8569f8c7601a05282c9d29778b4 (patch)
treec52178e2c9e2a18d994d408015a4e5e91606d57d /sql/updates/auth
parenta2e1bbaa1363aa0d86d494b02382d4768395c23e (diff)
Core/RBAC: Simplification part 1. Nobody needs different permissions for each type of .go command.
(cherry picked from commit 5843724debc3642434c055e5cf6f29a1eaf65358)
Diffstat (limited to 'sql/updates/auth')
-rw-r--r--sql/updates/auth/master/2018_09_06_00_auth.sql3
-rw-r--r--sql/updates/auth/master/2021_10_23_00_auth.sql3
2 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/auth/master/2018_09_06_00_auth.sql b/sql/updates/auth/master/2018_09_06_00_auth.sql
new file mode 100644
index 00000000000..5a9718edcfb
--- /dev/null
+++ b/sql/updates/auth/master/2018_09_06_00_auth.sql
@@ -0,0 +1,3 @@
+-- rbac simplify
+DELETE FROM `rbac_linked_permissions` WHERE `linkedid` IN (378,379,380,381,382,383,384,385,386,852,874);
+DELETE FROM `rbac_permissions` WHERE `id` IN (378,379,380,381,382,383,384,385,386,852,874);
diff --git a/sql/updates/auth/master/2021_10_23_00_auth.sql b/sql/updates/auth/master/2021_10_23_00_auth.sql
new file mode 100644
index 00000000000..5a0e26c23fe
--- /dev/null
+++ b/sql/updates/auth/master/2021_10_23_00_auth.sql
@@ -0,0 +1,3 @@
+-- rbac simplify
+DELETE FROM `rbac_linked_permissions` WHERE `linkedid` IN (834,799,800,801);
+DELETE FROM `rbac_permissions` WHERE `id` IN (834,799,800,801);