Debian Codegraph @

mysql-test/suite/roles/set_default_role_new_connection.test

raw
1 source include/not_embedded.inc;
2
3 create user test_user@localhost;
4 create role test_role;
5 grant select on *.* to test_role;
6 grant test_role to test_user@localhost;
7
8 --connect (c1, localhost, test_user,,)
9 show grants;
10 --error ER_TABLEACCESS_DENIED_ERROR
11 select user, host, default_role from mysql.user where user = 'test_user';
12 set default role test_role;
13 --error ER_TABLEACCESS_DENIED_ERROR
14 select user, host, default_role from mysql.user where user = 'test_user';
15 disconnect c1;
16
17 connection default;
18 select user, host, default_role from mysql.user where user = 'test_user';
19
20
21 --connect (c1, localhost, test_user,,)
22 show grants;
23 select user, host, default_role from mysql.user where user = 'test_user';
24 set default role NONE;
25 disconnect c1;
26
27 connection default;
28 select user, host, default_role from mysql.user where user = 'test_user';
29
30 --connect (c1, localhost, test_user,,)
31 show grants;
32 --error ER_TABLEACCESS_DENIED_ERROR
33 select user, host, default_role from mysql.user where user = 'test_user';
34 disconnect c1;
35
36 connection default;
37 select user, host, default_role from mysql.user where user = 'test_user';
38 set default role test_role for test_user@localhost;
39
40 --connect (c1, localhost, test_user,,)
41 show grants;
42 select user, host, default_role from mysql.user where user = 'test_user';
43 disconnect c1;
44
45 connection default;
46 drop role test_role;
47 drop user test_user@localhost;