Debian Codegraph @

mysql-test/suite/roles/set_role-database-recursive.test

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