Debian Codegraph @

mysql-test/suite/roles/set_role-table-simple.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 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 --sorted_result
32 select * from mysql.roles_mapping;
33
34 --sorted_result
35 show grants;
36
37 use mysql;
38
39 set role none;
40 select current_user(), current_role();
41
42 --sorted_result
43 --error ER_TABLEACCESS_DENIED_ERROR
44 select * from mysql.roles_mapping;
45
46 change_user 'root';
47 drop user 'test_user'@'localhost';
48 select * from mysql.tables_priv;
49 revoke select on mysql.roles_mapping from test_role2;
50 delete from mysql.user where user like'test_%';
51 delete from mysql.roles_mapping where Role like 'test%';
52
53 flush privileges;