Debian Codegraph @

mysql-test/suite/roles/set_default_role_new_connection.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 connect c1, localhost, test_user,,;
6 show grants;
7 Grants for test_user@localhost
8 GRANT `test_role` TO `test_user`@`localhost`
9 GRANT USAGE ON *.* TO `test_user`@`localhost`
10 select user, host, default_role from mysql.user where user = 'test_user';
11 ERROR 42000: SELECT command denied to user 'test_user'@'localhost' for table `mysql`.`user`
12 set default role test_role;
13 select user, host, default_role from mysql.user where user = 'test_user';
14 ERROR 42000: SELECT command denied to user 'test_user'@'localhost' for table `mysql`.`user`
15 disconnect c1;
16 connection default;
17 select user, host, default_role from mysql.user where user = 'test_user';
18 User Host default_role
19 test_user localhost test_role
20 connect c1, localhost, test_user,,;
21 show grants;
22 Grants for test_user@localhost
23 GRANT `test_role` TO `test_user`@`localhost`
24 GRANT USAGE ON *.* TO `test_user`@`localhost`
25 GRANT SELECT ON *.* TO `test_role`
26 SET DEFAULT ROLE `test_role` FOR `test_user`@`localhost`
27 select user, host, default_role from mysql.user where user = 'test_user';
28 User Host default_role
29 test_user localhost test_role
30 set default role NONE;
31 disconnect c1;
32 connection default;
33 select user, host, default_role from mysql.user where user = 'test_user';
34 User Host default_role
35 test_user localhost
36 connect c1, localhost, test_user,,;
37 show grants;
38 Grants for test_user@localhost
39 GRANT `test_role` TO `test_user`@`localhost`
40 GRANT USAGE ON *.* TO `test_user`@`localhost`
41 select user, host, default_role from mysql.user where user = 'test_user';
42 ERROR 42000: SELECT command denied to user 'test_user'@'localhost' for table `mysql`.`user`
43 disconnect c1;
44 connection default;
45 select user, host, default_role from mysql.user where user = 'test_user';
46 User Host default_role
47 test_user localhost
48 set default role test_role for test_user@localhost;
49 connect c1, localhost, test_user,,;
50 show grants;
51 Grants for test_user@localhost
52 GRANT `test_role` TO `test_user`@`localhost`
53 GRANT USAGE ON *.* TO `test_user`@`localhost`
54 GRANT SELECT ON *.* TO `test_role`
55 SET DEFAULT ROLE `test_role` FOR `test_user`@`localhost`
56 select user, host, default_role from mysql.user where user = 'test_user';
57 User Host default_role
58 test_user localhost test_role
59 disconnect c1;
60 connection default;
61 drop role test_role;
62 drop user test_user@localhost;