diff options
| author | Carbenium <carbenium@outlook.com> | 2021-06-26 22:47:26 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-03-12 23:00:17 +0100 |
| commit | b3b6e2715eb2a75805b7d879a1bef1074c085143 (patch) | |
| tree | 170e4b182e3fcf4083375308cfcb1227f177f5f9 /sql | |
| parent | 3c37dddeecd15c2bc7970b5d15199b1a03e5e18c (diff) | |
Scripts/Commands: Convert rbac commands to new system
Note: To enable rbac commands for administrators permissions 202-206 have to be linked to permission 196.
Sample SQL for auth DB:
INSERT INTO `rbac_linked_permissions` VALUES (196, 202), (196, 203), (196, 204), (196, 205), (196, 206);
(cherry picked from commit f620befc37fd8a4aed917e1ebba6f268c44a0a99)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/auth_database.sql | 7 | ||||
| -rw-r--r-- | sql/updates/world/master/2022_03_12_21_world_2021_08_14_00_world.sql | 5 |
2 files changed, 10 insertions, 2 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index 458044d58c3..72e89fde809 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -884,8 +884,11 @@ INSERT INTO `rbac_linked_permissions` VALUES (195,199), (196,7), (196,10), -(196,200), -(196,201), +(196,202), +(196,203), +(196,204), +(196,205), +(196,206), (196,208), (196,212), (196,213), diff --git a/sql/updates/world/master/2022_03_12_21_world_2021_08_14_00_world.sql b/sql/updates/world/master/2022_03_12_21_world_2021_08_14_00_world.sql new file mode 100644 index 00000000000..10b53a58095 --- /dev/null +++ b/sql/updates/world/master/2022_03_12_21_world_2021_08_14_00_world.sql @@ -0,0 +1,5 @@ +UPDATE `command` SET help='Syntax: rbac account revoke [$account] #id [#realmId] + +Remove a permission from an account + +Note: Removes the permission from granted or denied permissions' WHERE name='rbac account revoke'; |