Debian Codegraph @

mysql-test/suite/roles/none_public.result

raw
1 create role role1;
2 create role none;
3 ERROR OP000: Invalid role specification `NONE`
4 create role public;
5 ERROR OP000: Invalid role specification `PUBLIC`
6 drop role none;
7 ERROR HY000: Operation DROP ROLE failed for 'NONE'
8 drop role public;
9 ERROR HY000: Operation DROP ROLE failed for PUBLIC
10 grant none to role1;
11 ERROR OP000: Invalid role specification `NONE`
12 grant role1 to none;
13 ERROR OP000: Invalid role specification `none`
14 grant select on *.* to none;
15 ERROR OP000: Invalid role specification `none`
16 grant public to role1;
17 ERROR OP000: Invalid role specification `PUBLIC`
18 grant role1 to public;
19 grant select on *.* to public;
20 grant role1 to current_role;
21 ERROR OP000: Invalid role specification `NONE`
22 revoke none from role1;
23 ERROR OP000: Invalid role specification `NONE`
24 revoke role1 from none;
25 ERROR OP000: Invalid role specification `none`
26 revoke select on *.* from none;
27 ERROR OP000: Invalid role specification `none`
28 revoke public from role1;
29 ERROR OP000: Invalid role specification `PUBLIC`
30 revoke role1 from public;
31 revoke select on *.* from public;
32 show grants for none;
33 ERROR OP000: Invalid role specification `none`
34 show grants for public;
35 Grants for PUBLIC
36 create definer=none view test.v1 as select 1;
37 ERROR OP000: Invalid role specification `none`
38 create definer=public view test.v1 as select 1;
39 ERROR OP000: Invalid role specification `public`
40 drop role role1;
41 create user foo@localhost;
42 connect foo,localhost,foo;
43 set default role public;
44 ERROR OP000: Invalid role specification `PUBLIC`
45 disconnect foo;
46 connection default;
47 update mysql.global_priv set priv=json_insert(priv, '$.default_role', 'none') where user='foo';
48 connect foo,localhost,foo;
49 show grants;
50 Grants for foo@localhost
51 GRANT USAGE ON *.* TO `foo`@`localhost`
52 select * from information_schema.enabled_roles;
53 ROLE_NAME
54 NULL
55 disconnect foo;
56 connection default;
57 update mysql.global_priv set priv=json_insert(priv, '$.default_role', 'public') where user='foo';
58 connect foo,localhost,foo;
59 show grants;
60 Grants for foo@localhost
61 GRANT USAGE ON *.* TO `foo`@`localhost`
62 select * from information_schema.enabled_roles;
63 ROLE_NAME
64 NULL
65 disconnect foo;
66 connection default;
67 drop user foo@localhost;
68 insert mysql.global_priv values ('', 'none', '{"is_role":true}');
69 flush privileges;
70 Warnings:
71 Error 1959 Invalid role specification `none`
72 delete from mysql.global_priv where host='';