Debian Codegraph @

mysql-test/suite/roles/set_role-simple.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 grant test_role1 to test_user@localhost;
7 --sorted_result
8 select user, host from mysql.user where user not like 'root';
9 --sorted_result
10 select * from mysql.roles_mapping;
11 grant select on *.* to test_role1;
12 --sorted_result
13 select * from mysql.user where user='test_role1';
14
15 change_user 'test_user';
16
17 --error ER_TABLEACCESS_DENIED_ERROR
18 select * from mysql.roles_mapping;
19
20 --sorted_result
21 show grants;
22 select current_user(), current_role();
23 set role test_role1;
24 select current_user(), current_role();
25 --sorted_result
26 show grants;
27 --sorted_result
28 select * from mysql.roles_mapping;
29
30 set role none;
31 select current_user(), current_role();
32 --error ER_TABLEACCESS_DENIED_ERROR
33 select * from mysql.roles_mapping;
34
35 change_user 'root';
36 delete from mysql.user where user='test_role1';
37 delete from mysql.roles_mapping where Role='test_role1';
38 flush privileges;
39 drop user 'test_user'@'localhost';
40
41 #
42 # MDEV-9898 SET ROLE NONE can crash mysqld.
43 #
44
45 create user user1;
46
47 --connect (con1,localhost,user1,,)
48 select current_user;
49 show grants;
50 set role none;
51
52 connection default;
53 drop user user1;
54