Debian Codegraph @

mysql-test/suite/roles/set_default_role_clear.result

raw
1 create user test_user@localhost;
2 create role test_role;
3 grant select on *.* to test_role;
4 grant test_role to test_user@localhost;
5 show grants;
6 Grants for test_user@localhost
7 GRANT `test_role` TO `test_user`@`localhost`
8 GRANT USAGE ON *.* TO `test_user`@`localhost`
9 set default role test_role;
10 select user, host, default_role from mysql.user;
11 ERROR 42000: SELECT command denied to user 'test_user'@'localhost' for table `mysql`.`user`
12 select user, host, default_role from mysql.user where user='test_user';
13 User Host default_role
14 test_user localhost test_role
15 show grants;
16 Grants for test_user@localhost
17 GRANT `test_role` TO `test_user`@`localhost`
18 GRANT USAGE ON *.* TO `test_user`@`localhost`
19 GRANT SELECT ON *.* TO `test_role`
20 SET DEFAULT ROLE `test_role` FOR `test_user`@`localhost`
21 select user, host, default_role from mysql.user where user='test_user';
22 User Host default_role
23 test_user localhost test_role
24 set default role NONE;
25 select user, host, default_role from mysql.user where user='test_user';
26 User Host default_role
27 test_user localhost
28 set default role invalid_role;
29 ERROR OP000: Invalid role specification `invalid_role`
30 select user, host, default_role from mysql.user where user='test_user';
31 User Host default_role
32 test_user localhost
33 select user, host, default_role from mysql.user;
34 ERROR 42000: SELECT command denied to user 'test_user'@'localhost' for table `mysql`.`user`
35 drop role test_role;
36 drop user test_user@localhost;