Debian Codegraph @

mysql-test/suite/roles/rpl_definer.test

raw
1 #
2 # replication of the DEFINER=current_role
3 #
4
5 --source include/master-slave.inc
6
7 create role role1;
8 create role role2;
9 grant execute on test.* to role2;
10 grant role2 to role1;
11 set role role1;
12 --sorted_result
13 show grants;
14
15 create definer=current_user procedure pcu() select current_user;
16 create definer=root@localhost procedure pu() select "root@localhost";
17 create definer=current_role procedure pcr() select current_role;
18 create definer=role1 procedure pr() select "role1";
19
20 show create procedure pcu;
21 show create procedure pu;
22 show create procedure pcr;
23 show create procedure pr;
24
25 sync_slave_with_master;
26
27 set role role1;
28 --sorted_result
29 show grants;
30
31 show create procedure pcu;
32 show create procedure pu;
33 show create procedure pcr;
34 show create procedure pr;
35
36 connection master;
37
38 drop procedure pcu;
39 drop procedure pu;
40 drop procedure pcr;
41 drop procedure pr;
42 drop role role1;
43 drop role role2;
44
45 --source include/rpl_end.inc
46