diff options
| author | Carbenium <carbenium@outlook.com> | 2021-06-26 22:47:26 +0200 |
|---|---|---|
| committer | Peter Keresztes Schmidt <carbenium@outlook.com> | 2021-08-14 12:50:18 +0200 |
| commit | f620befc37fd8a4aed917e1ebba6f268c44a0a99 (patch) | |
| tree | 19ae6e890e936157a9547399f658559efa1a2dbb /sql | |
| parent | 8ee92147a5435600992d7269b98edd5d36cd8924 (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);
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/auth_database.sql | 7 | ||||
| -rw-r--r-- | sql/updates/world/3.3.5/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 e2b97df7aaf..eb77012c356 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -521,8 +521,11 @@ INSERT INTO `rbac_linked_permissions` VALUES (195,49), (195,199), (196,7), -(196,200), -(196,201), +(196,202), +(196,203), +(196,204), +(196,205), +(196,206), (196,226), (196,227), (196,230), diff --git a/sql/updates/world/3.3.5/2021_08_14_00_world.sql b/sql/updates/world/3.3.5/2021_08_14_00_world.sql new file mode 100644 index 00000000000..10b53a58095 --- /dev/null +++ b/sql/updates/world/3.3.5/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'; |
