Debian Codegraph @

mysql-test/suite/roles/i_s_applicable_roles_is_default.test

raw
1 --source include/not_embedded.inc
2 create user foo;
3 create role role1;
4 create role role2;
5 create role role3;
6
7 grant role1 to foo;
8 grant role2 to role1;
9 grant role3 to foo;
10
11
12 connect (foo, localhost, foo);
13 --sorted_result
14 select * from information_schema.applicable_roles;
15
16 set default role role3;
17 --sorted_result
18 select * from information_schema.applicable_roles;
19
20 set default role role1;
21 --sorted_result
22 select * from information_schema.applicable_roles;
23
24
25 disconnect foo;
26 connection default;
27
28 --sorted_result
29 select * from information_schema.applicable_roles;
30
31 set default role none for foo;
32 connect (foo, localhost, foo);
33 --sorted_result
34 select * from information_schema.applicable_roles;
35
36 disconnect foo;
37 connection default;
38
39 --sorted_result
40 select * from information_schema.applicable_roles;
41
42 set default role role1;
43 --sorted_result
44 select * from information_schema.applicable_roles;
45
46 set default role role2;
47 --sorted_result
48 select * from information_schema.applicable_roles;
49
50 set default role role3;
51 --sorted_result
52 select * from information_schema.applicable_roles;
53
54 set default role none;
55 --sorted_result
56 select * from information_schema.applicable_roles;
57
58 drop role role3;
59 drop role role2;
60 drop role role1;
61 drop user foo;
62 update mysql.global_priv set priv=json_compact(json_remove(priv, '$.default_role'));