aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/auth
diff options
context:
space:
mode:
Diffstat (limited to 'sql/updates/auth')
-rw-r--r--sql/updates/auth/2013_10_16_00_auth_misc.sql11
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/auth/2013_10_16_00_auth_misc.sql b/sql/updates/auth/2013_10_16_00_auth_misc.sql
new file mode 100644
index 00000000000..cd7e8b3ae40
--- /dev/null
+++ b/sql/updates/auth/2013_10_16_00_auth_misc.sql
@@ -0,0 +1,11 @@
+SET @id = 400;
+
+-- Add new permissions
+DELETE FROM `rbac_permissions` WHERE `id`=@id;
+INSERT INTO `rbac_permissions` (`id`, `name`) VALUES
+(@id, 'debug transport');
+
+-- Add permissions to "corresponding Commands Role"
+DELETE FROM `rbac_role_permissions` WHERE `permissionId`=@id;
+INSERT INTO `rbac_role_permissions` (`roleId`, `permissionId`) VALUES
+(3, @id);