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