Core/RBAC: Add new Permission "Log gm trade". Config option still active, but will affect only to users with that permission granted

1 files changed, 14 insertions, 0 deletions

diff --git a/sql/updates/auth/2013_02_25_00_auth_misc.sql b/sql/updates/auth/2013_02_25_00_auth_misc.sql
new file mode 100644
index 00000000000..fbbf47f1a23
--- /dev/null
+++ b/sql/updates/auth/2013_02_25_00_auth_misc.sql
@@ -0,0 +1,14 @@
+-- Add new permission
+INSERT INTO `rbac_permissions` (`id`, `name`) VALUES (11, 'Log GM trades');
+
+-- Add new role
+INSERT INTO `rbac_roles` (`id`, `name`) VALUES (8, 'Log GM trades');
+
+-- Add the permission to the role
+INSERT INTO `rbac_role_permissions` (`roleId`, `permissionId`) VALUES (8, 11);
+
+-- Add it to all GM+ groups
+INSERT INTO `rbac_group_roles` (`groupId`, `roleId`) VALUES
+(2, 8),
+(3, 8),
+(4, 8);