Debian Codegraph @

mysql-test/suite/roles/set_default_role_clear.test

raw
1 source include/not_embedded.inc;
2
3 # This test checks clearing a default role from a user.
4
5 # Create a user with no privileges
6 create user test_user@localhost;
7
8 create role test_role;
9
10 grant select on *.* to test_role;
11 grant test_role to test_user@localhost;
12
13 change_user 'test_user';
14 show grants;
15 set default role test_role;
16
17 # Even though a user has the default role set, without reconnecting, we should
18 # not already have the roles privileges.
19 --error ER_TABLEACCESS_DENIED_ERROR
20 select user, host, default_role from mysql.user;
21
22 change_user 'root';
23 select user, host, default_role from mysql.user where user='test_user';
24
25 change_user 'test_user';
26 # This should show that the new test_user has the role's grants enabled.
27 show grants;
28 select user, host, default_role from mysql.user where user='test_user';
29
30 set default role NONE;
31
32 # We should still have the role set right now.
33 select user, host, default_role from mysql.user where user='test_user';
34
35 # Make sure we do not somehow get privileges to set an invalid role
36 --error ER_INVALID_ROLE
37 set default role invalid_role;
38
39 change_user 'root';
40 select user, host, default_role from mysql.user where user='test_user';
41
42 change_user 'test_user';
43 # The user does not have a default role set anymore. Make sure we don't still
44 # get the privileges.
45 --error ER_TABLEACCESS_DENIED_ERROR
46 select user, host, default_role from mysql.user;
47
48 change_user 'root';
49
50 # Cleanup
51 drop role test_role;
52 drop user test_user@localhost;