diff options
Diffstat (limited to 'mysql-test/suite/roles/set_default_role_clear.result')
| -rw-r--r-- | mysql-test/suite/roles/set_default_role_clear.result | 36 |
1 files changed, 36 insertions, 0 deletions
diff --git a/mysql-test/suite/roles/set_default_role_clear.result b/mysql-test/suite/roles/set_default_role_clear.result new file mode 100644 index 00000000..8a3ae908 --- /dev/null +++ b/mysql-test/suite/roles/set_default_role_clear.result @@ -0,0 +1,36 @@ +create user test_user@localhost; +create role test_role; +grant select on *.* to test_role; +grant test_role to test_user@localhost; +show grants; +Grants for test_user@localhost +GRANT `test_role` TO `test_user`@`localhost` +GRANT USAGE ON *.* TO `test_user`@`localhost` +set default role test_role; +select user, host, default_role from mysql.user; +ERROR 42000: SELECT command denied to user 'test_user'@'localhost' for table `mysql`.`user` +select user, host, default_role from mysql.user where user='test_user'; +User Host default_role +test_user localhost test_role +show grants; +Grants for test_user@localhost +GRANT `test_role` TO `test_user`@`localhost` +GRANT USAGE ON *.* TO `test_user`@`localhost` +GRANT SELECT ON *.* TO `test_role` +SET DEFAULT ROLE `test_role` FOR `test_user`@`localhost` +select user, host, default_role from mysql.user where user='test_user'; +User Host default_role +test_user localhost test_role +set default role NONE; +select user, host, default_role from mysql.user where user='test_user'; +User Host default_role +test_user localhost +set default role invalid_role; +ERROR OP000: Invalid role specification `invalid_role` +select user, host, default_role from mysql.user where user='test_user'; +User Host default_role +test_user localhost +select user, host, default_role from mysql.user; +ERROR 42000: SELECT command denied to user 'test_user'@'localhost' for table `mysql`.`user` +drop role test_role; +drop user test_user@localhost; |