Debian Codegraph @

mysql-test/suite/roles/set_default_role_invalid_skip_name_resolve.result

raw
1 #
2 # MDEV-26875: Wrong user in SET DEFAULT ROLE error
3 #
4 create user test_user;
5 create role test_role;
6 show grants for test_user;
7 Grants for test_user@%
8 GRANT USAGE ON *.* TO `test_user`@`%`
9 set default role test_role for test_user;
10 ERROR OP000: User `test_user`@`%` has not been granted role `test_role`
11 grant test_role to test_user;
12 set default role test_role for test_user;
13 show grants for test_user;
14 Grants for test_user@%
15 GRANT `test_role` TO `test_user`@`%`
16 GRANT USAGE ON *.* TO `test_user`@`%`
17 SET DEFAULT ROLE `test_role` FOR `test_user`@`%`
18 set default role none for test_user;
19 #
20 # Try to set default role to role(`test_role`).
21 --------------------------------------------------------------
22 show grants for test_role;
23 Grants for test_role
24 GRANT USAGE ON *.* TO `test_role`
25 create role new_role;
26 grant new_role to test_role;
27 show grants for test_role;
28 Grants for test_role
29 GRANT `new_role` TO `test_role`
30 GRANT USAGE ON *.* TO `test_role`
31 GRANT USAGE ON *.* TO `new_role`
32 set default role new_role for test_role;
33 ERROR OP000: User `test_role`@`%` has not been granted role `new_role`
34 #
35 # Test of errors, where hostname cannot be resolved `test_user`
36 --------------------------------------------------------------
37 grant test_role to test_user@'%';
38 set default role test_role for test_user@'%';
39 connect con_test_user,127.0.0.1,test_user,,,$MASTER_MYPORT;
40 show grants;
41 Grants for test_user@%
42 GRANT `test_role` TO `test_user`@`%`
43 GRANT USAGE ON *.* TO `test_user`@`%`
44 GRANT `new_role` TO `test_role`
45 GRANT USAGE ON *.* TO `test_role`
46 GRANT USAGE ON *.* TO `new_role`
47 SET DEFAULT ROLE `test_role` FOR `test_user`@`%`
48 select current_role;
49 current_role
50 test_role
51 set role `new_role`;
52 ERROR OP000: User `test_user`@`%` has not been granted role `new_role`
53 connection default;
54 set default role none for test_user;
55 disconnect con_test_user;
56 connect con_test_user,127.0.0.1,test_user,,,$MASTER_MYPORT;
57 select current_role;
58 current_role
59 NULL
60 set role `new_role`;
61 ERROR OP000: User `test_user`@`%` has not been granted role `new_role`
62 connection default;
63 disconnect con_test_user;
64 #
65 # Test of anonymous user connection
66 --------------------------------------------------------------
67 grant test_role to ''@localhost;
68 connect con1,localhost,'',,,$MASTER_MYPORT;
69 SELECT CURRENT_ROLE;
70 CURRENT_ROLE
71 NULL
72 SET role test_role;
73 SELECT CURRENT_ROLE;
74 CURRENT_ROLE
75 test_role
76 SET role new_role;
77 ERROR OP000: User ``@`localhost` has not been granted role `new_role`
78 set default role test_role for ''@localhost;
79 ERROR 42000: You are using MariaDB as an anonymous user and anonymous users are not allowed to modify user settings
80 connection default;
81 disconnect con1;
82 REVOKE all privileges, grant option from ''@localhost;
83 drop role new_role;
84 drop role test_role;
85 drop user test_user;