Debian Codegraph @

mysql-test/suite/roles/rpl_definer.result

raw
1 include/master-slave.inc
2 [connection master]
3 create role role1;
4 create role role2;
5 grant execute on test.* to role2;
6 grant role2 to role1;
7 set role role1;
8 show grants;
9 Grants for root@localhost
10 GRANT ALL PRIVILEGES ON *.* TO `root`@`localhost` WITH GRANT OPTION
11 GRANT EXECUTE ON `test`.* TO `role2`
12 GRANT PROXY ON ''@'%' TO 'root'@'localhost' WITH GRANT OPTION
13 GRANT USAGE ON *.* TO `role1`
14 GRANT USAGE ON *.* TO `role2`
15 GRANT `role1` TO `root`@`localhost` WITH ADMIN OPTION
16 GRANT `role2` TO `role1`
17 GRANT `role2` TO `root`@`localhost` WITH ADMIN OPTION
18 create definer=current_user procedure pcu() select current_user;
19 create definer=root@localhost procedure pu() select "root@localhost";
20 create definer=current_role procedure pcr() select current_role;
21 create definer=role1 procedure pr() select "role1";
22 show create procedure pcu;
23 Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
24 pcu STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` PROCEDURE `pcu`()
25 select current_user latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
26 show create procedure pu;
27 Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
28 pu STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` PROCEDURE `pu`()
29 select "root@localhost" latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
30 show create procedure pcr;
31 Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
32 pcr STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`role1` PROCEDURE `pcr`()
33 select current_role latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
34 show create procedure pr;
35 Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
36 pr STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`role1` PROCEDURE `pr`()
37 select "role1" latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
38 connection slave;
39 set role role1;
40 show grants;
41 Grants for root@localhost
42 GRANT ALL PRIVILEGES ON *.* TO `root`@`localhost` WITH GRANT OPTION
43 GRANT EXECUTE ON `test`.* TO `role2`
44 GRANT PROXY ON ''@'%' TO 'root'@'localhost' WITH GRANT OPTION
45 GRANT USAGE ON *.* TO `role1`
46 GRANT USAGE ON *.* TO `role2`
47 GRANT `role1` TO `root`@`localhost` WITH ADMIN OPTION
48 GRANT `role2` TO `role1`
49 GRANT `role2` TO `root`@`localhost` WITH ADMIN OPTION
50 show create procedure pcu;
51 Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
52 pcu STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` PROCEDURE `pcu`()
53 select current_user latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
54 show create procedure pu;
55 Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
56 pu STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` PROCEDURE `pu`()
57 select "root@localhost" latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
58 show create procedure pcr;
59 Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
60 pcr STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`role1` PROCEDURE `pcr`()
61 select current_role latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
62 show create procedure pr;
63 Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
64 pr STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`role1` PROCEDURE `pr`()
65 select "role1" latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
66 connection master;
67 drop procedure pcu;
68 drop procedure pu;
69 drop procedure pcr;
70 drop procedure pr;
71 drop role role1;
72 drop role role2;
73 include/rpl_end.inc