Debian Codegraph @

mysql-test/suite/roles/set_default_role_invalid_skip_name_resolve.test

raw
1 source include/not_embedded.inc;
2
3 --echo #
4 --echo # MDEV-26875: Wrong user in SET DEFAULT ROLE error
5 --echo #
6 create user test_user;
7 create role test_role;
8 show grants for test_user;
9 --error ER_INVALID_ROLE
10 set default role test_role for test_user;
11 grant test_role to test_user;
12 set default role test_role for test_user;
13 show grants for test_user;
14 set default role none for test_user;
15
16 --echo #
17 --echo # Try to set default role to role(`test_role`).
18 --echo --------------------------------------------------------------
19 show grants for test_role;
20 create role new_role;
21 grant new_role to test_role;
22 show grants for test_role;
23 # One can not set role to a role
24 --error ER_INVALID_ROLE
25 set default role new_role for test_role;
26
27 --echo #
28 --echo # Test of errors, where hostname cannot be resolved `test_user`
29 --echo --------------------------------------------------------------
30 # `new_role` is granted to `test_role`
31 grant test_role to test_user@'%';
32 set default role test_role for test_user@'%';
33
34 connect con_test_user,127.0.0.1,test_user,,,$MASTER_MYPORT;
35 show grants;
36 select current_role;
37 # `test_user` indirectly granted `new_role`
38 --error ER_INVALID_ROLE
39 set role `new_role`;
40
41 connection default;
42 set default role none for test_user;
43 disconnect con_test_user;
44
45 connect con_test_user,127.0.0.1,test_user,,,$MASTER_MYPORT;
46 select current_role;
47 --error ER_INVALID_ROLE
48 set role `new_role`;
49
50 connection default;
51 disconnect con_test_user;
52
53 --echo #
54 --echo # Test of anonymous user connection
55 --echo --------------------------------------------------------------
56 --source include/add_anonymous_users.inc
57 # Skip windows, since it uses current user `Administrator` in buildbot.
58 --source include/not_windows.inc
59 grant test_role to ''@localhost;
60
61 connect(con1,localhost,'',,,$MASTER_MYPORT);
62 SELECT CURRENT_ROLE;
63 SET role test_role;
64 SELECT CURRENT_ROLE;
65 # user cannot set subset role, since it is not granted explicitly
66 --error ER_INVALID_ROLE
67 SET role new_role;
68 --error ER_PASSWORD_ANONYMOUS_USER
69 set default role test_role for ''@localhost;
70
71 connection default;
72 disconnect con1;
73 REVOKE all privileges, grant option from ''@localhost;
74 --source include/delete_anonymous_users.inc
75
76 drop role new_role;
77 drop role test_role;
78 drop user test_user;