diff options
| author | Vicențiu Ciorbaru <vicentiu@mariadb.org> | 2016-03-22 13:45:51 +0200 |
|---|---|---|
| committer | Vicențiu Ciorbaru <vicentiu@mariadb.org> | 2016-03-22 22:21:04 +0200 |
| commit | 287f2d2947c15d1e7ff35ba123b37291147e1c85 (patch) | |
| tree | 79acb6f0507fa802a8637f0b406de27ffcd05d1c /mysql-test | |
| parent | c4bef7ad3c1528e902e88aa8b2446f29ffc1b0e6 (diff) | |
| download | mariadb-git-287f2d2947c15d1e7ff35ba123b37291147e1c85.tar.gz | |
MDEV-9443: Add REVOKE <role> as a command to PREPARE
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/suite/roles/prepare_stmt_with_role.result | 9 | ||||
| -rw-r--r-- | mysql-test/suite/roles/prepare_stmt_with_role.test | 9 |
2 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/suite/roles/prepare_stmt_with_role.result b/mysql-test/suite/roles/prepare_stmt_with_role.result index 8b647bf2849..71dffaafa92 100644 --- a/mysql-test/suite/roles/prepare_stmt_with_role.result +++ b/mysql-test/suite/roles/prepare_stmt_with_role.result @@ -38,6 +38,15 @@ Grants for test_user@% GRANT developers TO 'test_user'@'%' GRANT USAGE ON *.* TO 'test_user'@'%' # +# Test revoking a role. +# +SET @revokeRole = 'REVOKE developers FROM test_user'; +PREPARE stmtRevokeRole FROM @revokeRole; +EXECUTE stmtRevokeRole; +SHOW GRANTS FOR test_user; +Grants for test_user@% +GRANT USAGE ON *.* TO 'test_user'@'%' +# # Now drop the role. # SET @dropRole = 'DROP ROLE developers'; diff --git a/mysql-test/suite/roles/prepare_stmt_with_role.test b/mysql-test/suite/roles/prepare_stmt_with_role.test index 233249521b6..be2c92b3e36 100644 --- a/mysql-test/suite/roles/prepare_stmt_with_role.test +++ b/mysql-test/suite/roles/prepare_stmt_with_role.test @@ -33,6 +33,15 @@ SELECT * FROM mysql.roles_mapping; SHOW GRANTS FOR test_user; --echo # +--echo # Test revoking a role. +--echo # +SET @revokeRole = 'REVOKE developers FROM test_user'; +PREPARE stmtRevokeRole FROM @revokeRole; +EXECUTE stmtRevokeRole; + +SHOW GRANTS FOR test_user; + +--echo # --echo # Now drop the role. --echo # SET @dropRole = 'DROP ROLE developers'; |