Debian Codegraph @

mysql-test/suite/roles/drop_routines.result

raw
1 create role r1;
2 create role r2;
3 create role r3;
4 create user u1;
5 grant r2 to r1;
6 grant r3 to r2;
7 grant r1 to u1;
8 show grants for u1;
9 Grants for u1@%
10 GRANT USAGE ON *.* TO `u1`@`%`
11 GRANT `r1` TO `u1`@`%`
12 show grants for r1;
13 Grants for r1
14 GRANT USAGE ON *.* TO `r1`
15 GRANT USAGE ON *.* TO `r2`
16 GRANT USAGE ON *.* TO `r3`
17 GRANT `r2` TO `r1`
18 GRANT `r3` TO `r2`
19 grant SELECT on *.* to u1;
20 grant INSERT on mysql.* to r1;
21 grant DELETE on mysql.roles_mapping to r2;
22 grant UPDATE on mysql.user to r3;
23 create function mysql.test_func (s CHAR(20))
24 returns CHAR(50) DETERMINISTIC
25 return concat('Test string: ',s);
26 create procedure mysql.test_proc (OUT param1 INT)
27 begin
28 select COUNT(*) into param1 from mysql.roles_mapping;
29 end|
30 grant execute on function mysql.test_func to r2;
31 grant execute on procedure mysql.test_proc to r3;
32 revoke execute on procedure mysql.test_proc from r2;
33 ERROR 42000: There is no such grant defined for user 'r2' on host '' on routine 'test_proc'
34 show grants for r1;
35 Grants for r1
36 GRANT DELETE ON `mysql`.`roles_mapping` TO `r2`
37 GRANT EXECUTE ON FUNCTION `mysql`.`test_func` TO `r2`
38 GRANT EXECUTE ON PROCEDURE `mysql`.`test_proc` TO `r3`
39 GRANT INSERT ON `mysql`.* TO `r1`
40 GRANT UPDATE ON `mysql`.`user` TO `r3`
41 GRANT USAGE ON *.* TO `r1`
42 GRANT USAGE ON *.* TO `r2`
43 GRANT USAGE ON *.* TO `r3`
44 GRANT `r2` TO `r1`
45 GRANT `r3` TO `r2`
46 show grants for r2;
47 Grants for r2
48 GRANT DELETE ON `mysql`.`roles_mapping` TO `r2`
49 GRANT EXECUTE ON FUNCTION `mysql`.`test_func` TO `r2`
50 GRANT EXECUTE ON PROCEDURE `mysql`.`test_proc` TO `r3`
51 GRANT UPDATE ON `mysql`.`user` TO `r3`
52 GRANT USAGE ON *.* TO `r2`
53 GRANT USAGE ON *.* TO `r3`
54 GRANT `r3` TO `r2`
55 show grants for r3;
56 Grants for r3
57 GRANT EXECUTE ON PROCEDURE `mysql`.`test_proc` TO `r3`
58 GRANT UPDATE ON `mysql`.`user` TO `r3`
59 GRANT USAGE ON *.* TO `r3`
60 drop function mysql.test_func;
61 drop procedure mysql.test_proc;
62 create function mysql.test_func (s CHAR(20))
63 returns CHAR(50) DETERMINISTIC
64 return concat('Test string: ',s);
65 show grants for r2;
66 Grants for r2
67 GRANT DELETE ON `mysql`.`roles_mapping` TO `r2`
68 GRANT UPDATE ON `mysql`.`user` TO `r3`
69 GRANT USAGE ON *.* TO `r2`
70 GRANT USAGE ON *.* TO `r3`
71 GRANT `r3` TO `r2`
72 connect u1,localhost,u1,,;
73 select mysql.test_func("none");
74 ERROR 42000: execute command denied to user 'u1'@'%' for routine 'mysql.test_func'
75 set role r1;
76 select mysql.test_func("r1");
77 ERROR 42000: execute command denied to user 'u1'@'%' for routine 'mysql.test_func'
78 connection default;
79 drop function mysql.test_func;
80 drop role r1, r2, r3;
81 drop user u1;