Debian Codegraph @

mysql-test/suite/roles/none_public.test

raw
1 source include/not_embedded.inc;
2
3 create role role1;
4
5 --error ER_INVALID_ROLE
6 create role none;
7 --error ER_INVALID_ROLE
8 create role public;
9 --error ER_CANNOT_USER
10 drop role none;
11 --error ER_CANNOT_USER
12 drop role public;
13
14 --error ER_INVALID_ROLE
15 grant none to role1;
16 --error ER_INVALID_ROLE
17 grant role1 to none;
18 --error ER_INVALID_ROLE
19 grant select on *.* to none;
20 --error ER_INVALID_ROLE
21 grant public to role1;
22 grant role1 to public;
23 grant select on *.* to public;
24
25 --error ER_INVALID_ROLE
26 grant role1 to current_role;
27
28 --error ER_INVALID_ROLE
29 revoke none from role1;
30 --error ER_INVALID_ROLE
31 revoke role1 from none;
32 --error ER_INVALID_ROLE
33 revoke select on *.* from none;
34 --error ER_INVALID_ROLE
35 revoke public from role1;
36 revoke role1 from public;
37 revoke select on *.* from public;
38
39 --error ER_INVALID_ROLE
40 show grants for none;
41 show grants for public;
42
43 --error ER_INVALID_ROLE
44 create definer=none view test.v1 as select 1;
45 --error ER_INVALID_ROLE
46 create definer=public view test.v1 as select 1;
47
48 drop role role1;
49
50 create user foo@localhost;
51 connect foo,localhost,foo;
52 --error ER_INVALID_ROLE
53 set default role public;
54 disconnect foo;
55
56 connection default;
57 update mysql.global_priv set priv=json_insert(priv, '$.default_role', 'none') where user='foo';
58 connect foo,localhost,foo;
59 show grants;
60 select * from information_schema.enabled_roles;
61 disconnect foo;
62
63 connection default;
64 update mysql.global_priv set priv=json_insert(priv, '$.default_role', 'public') where user='foo';
65 connect foo,localhost,foo;
66 show grants;
67 select * from information_schema.enabled_roles;
68 disconnect foo;
69
70 connection default;
71 drop user foo@localhost;
72
73 insert mysql.global_priv values ('', 'none', '{"is_role":true}');
74 flush privileges;
75 delete from mysql.global_priv where host='';