Debian Codegraph @

mysql-test/suite/roles/i_s_applicable_roles_is_default.result

raw
1 create user foo;
2 create role role1;
3 create role role2;
4 create role role3;
5 grant role1 to foo;
6 grant role2 to role1;
7 grant role3 to foo;
8 connect foo, localhost, foo;
9 select * from information_schema.applicable_roles;
10 GRANTEE ROLE_NAME IS_GRANTABLE IS_DEFAULT
11 foo@% role1 NO NO
12 foo@% role3 NO NO
13 role1 role2 NO NULL
14 set default role role3;
15 select * from information_schema.applicable_roles;
16 GRANTEE ROLE_NAME IS_GRANTABLE IS_DEFAULT
17 foo@% role1 NO NO
18 foo@% role3 NO YES
19 role1 role2 NO NULL
20 set default role role1;
21 select * from information_schema.applicable_roles;
22 GRANTEE ROLE_NAME IS_GRANTABLE IS_DEFAULT
23 foo@% role1 NO YES
24 foo@% role3 NO NO
25 role1 role2 NO NULL
26 disconnect foo;
27 connection default;
28 select * from information_schema.applicable_roles;
29 GRANTEE ROLE_NAME IS_GRANTABLE IS_DEFAULT
30 role1 role2 NO NULL
31 root@localhost role1 YES NO
32 root@localhost role2 YES NO
33 root@localhost role3 YES NO
34 set default role none for foo;
35 connect foo, localhost, foo;
36 select * from information_schema.applicable_roles;
37 GRANTEE ROLE_NAME IS_GRANTABLE IS_DEFAULT
38 foo@% role1 NO NO
39 foo@% role3 NO NO
40 role1 role2 NO NULL
41 disconnect foo;
42 connection default;
43 select * from information_schema.applicable_roles;
44 GRANTEE ROLE_NAME IS_GRANTABLE IS_DEFAULT
45 role1 role2 NO NULL
46 root@localhost role1 YES NO
47 root@localhost role2 YES NO
48 root@localhost role3 YES NO
49 set default role role1;
50 select * from information_schema.applicable_roles;
51 GRANTEE ROLE_NAME IS_GRANTABLE IS_DEFAULT
52 role1 role2 NO NULL
53 root@localhost role1 YES YES
54 root@localhost role2 YES NO
55 root@localhost role3 YES NO
56 set default role role2;
57 select * from information_schema.applicable_roles;
58 GRANTEE ROLE_NAME IS_GRANTABLE IS_DEFAULT
59 role1 role2 NO NULL
60 root@localhost role1 YES NO
61 root@localhost role2 YES YES
62 root@localhost role3 YES NO
63 set default role role3;
64 select * from information_schema.applicable_roles;
65 GRANTEE ROLE_NAME IS_GRANTABLE IS_DEFAULT
66 role1 role2 NO NULL
67 root@localhost role1 YES NO
68 root@localhost role2 YES NO
69 root@localhost role3 YES YES
70 set default role none;
71 select * from information_schema.applicable_roles;
72 GRANTEE ROLE_NAME IS_GRANTABLE IS_DEFAULT
73 role1 role2 NO NULL
74 root@localhost role1 YES NO
75 root@localhost role2 YES NO
76 root@localhost role3 YES NO
77 drop role role3;
78 drop role role2;
79 drop role role1;
80 drop user foo;
81 update mysql.global_priv set priv=json_compact(json_remove(priv, '$.default_role'));