Debian Codegraph @

mysql-test/suite/roles/set_role-table-column-priv.test

raw
1 source include/not_embedded.inc;
2
3 create user test_user@localhost;
4 create role test_role1;
5 create role test_role2;
6
7 grant test_role1 to test_user@localhost;
8 grant test_role2 to test_role1;
9 --sorted_result
10 select user, host from mysql.user where user not like 'root';
11 --sorted_result
12 select * from mysql.roles_mapping;
13
14 grant select (Role) on mysql.roles_mapping to test_role2;
15
16 change_user 'test_user';
17
18 --error ER_TABLEACCESS_DENIED_ERROR
19 select * from mysql.roles_mapping;
20
21 --sorted_result
22 show grants;
23
24 select current_user(), current_role();
25 set role test_role1;
26 select current_user(), current_role();
27
28 --sorted_result
29 show grants;
30
31 --error ER_COLUMNACCESS_DENIED_ERROR
32 select * from mysql.roles_mapping;
33
34 --sorted_result
35 select Role from mysql.roles_mapping;
36
37 --sorted_result
38 show grants;
39
40 use mysql;
41
42 set role none;
43 select current_user(), current_role();
44
45 --sorted_result
46 --error ER_TABLEACCESS_DENIED_ERROR
47 select Role from mysql.roles_mapping;
48
49 change_user 'root';
50 drop user 'test_user'@'localhost';
51 select * from mysql.tables_priv;
52 revoke select on mysql.roles_mapping from test_role2;
53 delete from mysql.user where user like'test_%';
54 delete from mysql.roles_mapping where Role like 'test%';
55
56 flush privileges;