Debian Codegraph @

mysql-test/suite/group_replication/t/gr_variables_privileges.test

raw
1 ################################################################################
2 # This test is to verify privileges required by a user to set/update group
3 # replication(GR) variables.
4 #
5 # Test:
6 # 0. The test requires one server.
7 # 1. Create an user which lacks privileges.
8 # 2. Expect ER_SPECIFIC_ACCESS_DENIED_ERROR when setting GR global variables.
9 # 3. Grant SYSTEM_VARIABLES_ADMIN and verify setting group replication
10 # variables at global scope succeed, except group_replication_consistency
11 # which also needs GROUP_REPLICATION_ADMIN privilege.
12 # 4. Grant GROUP_REPLICATION_ADMIN and verify setting
13 # group_replication_consistency at global scope succeeds.
14 # 5. Clean up.
15 ################################################################################
16 --source include/have_group_replication_plugin.inc
17 --let $rpl_skip_group_replication_start= 1
18 --source include/group_replication.inc
19
20 --echo
21 --echo ############################################################
22 --echo # 1. Create an user which lacks privileges.
23
24 --let $rpl_connection_name= server1
25 --source include/rpl_connection.inc
26
27 --replace_result $group_replication_group_name GROUP_REPLICATION_GROUP_NAME
28 --eval SET GLOBAL group_replication_group_name= "$group_replication_group_name"
29
30 CREATE USER 'no_priv_user'@localhost IDENTIFIED BY '';
31 GRANT ALL ON *.* TO 'no_priv_user'@localhost;
32 --disable_warnings
33 REVOKE SUPER, SYSTEM_VARIABLES_ADMIN, SESSION_VARIABLES_ADMIN, GROUP_REPLICATION_ADMIN
34 ON *.* FROM 'no_priv_user'@localhost;
35 --enable_warnings
36
37 --echo
38 --echo ############################################################
39 --echo # 2. Expect ER_SPECIFIC_ACCESS_DENIED_ERROR when setting GR
40 --echo # global variables since user lacks SUPER or
41 --echo # SYSTEM_VARIABLES_ADMIN privileges.
42
43 CREATE TABLE gr_vars (id INT PRIMARY KEY AUTO_INCREMENT, var_name VARCHAR(64), var_value VARCHAR(256));
44 INSERT INTO gr_vars (var_name, var_value)
45 SELECT * FROM performance_schema.global_variables
46 WHERE VARIABLE_NAME LIKE '%group_replication%'
47 ORDER BY VARIABLE_NAME;
48
49 --let $count_vars= `SELECT COUNT(*) FROM gr_vars;`
50
51 --connect (no_priv_user_con,localhost,no_priv_user,,test,$MASTER_MYPORT,,)
52 --let $rpl_connection_name= no_priv_user_con
53 --source include/rpl_connection.inc
54
55 --echo
56 --echo # Expect ER_SPECIFIC_ACCESS_DENIED_ERROR for global variables.
57 --let $var_id=1
58 while ( $var_id <= $count_vars )
59 {
60 --let $var_names= `SELECT var_name FROM gr_vars WHERE id=$var_id`
61 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
62 --eval SET GLOBAL $var_names = @@GLOBAL.$var_names
63 --inc $var_id
64 }
65
66 # Session variable(s)
67 --echo
68 --echo # Like most system variables, setting the session value for
69 --echo # group_replication_consistency requires no special privileges.
70 SET SESSION group_replication_consistency = @@SESSION.group_replication_consistency;
71
72 --echo
73 --echo ############################################################
74 --echo # 3. Grant SYSTEM_VARIABLES_ADMIN and verify setting group
75 --echo # replication variables at global scope succeed, except
76 --echo # group_replication_consistency which also needs
77 --echo # GROUP_REPLICATION_ADMIN privilege.
78
79 --let $rpl_connection_name= server1
80 --source include/rpl_connection.inc
81 GRANT SYSTEM_VARIABLES_ADMIN, SESSION_VARIABLES_ADMIN ON *.* TO 'no_priv_user'@localhost;
82
83 --let $rpl_connection_name= no_priv_user_con
84 --source include/rpl_connection.inc
85
86 --echo
87 --let $var_id=1
88 while ( $var_id <= $count_vars )
89 {
90 --let $var_names= `SELECT var_name FROM gr_vars WHERE id=$var_id`
91 if ($var_names == "group_replication_consistency")
92 {
93 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
94 }
95 --eval SET GLOBAL $var_names = @@GLOBAL.$var_names
96 --inc $var_id
97 }
98
99 --echo
100 --echo ############################################################
101 --echo # 4. Grant GROUP_REPLICATION_ADMIN and verify setting
102 --echo # group_replication_consistency at global scope succeeds.
103
104 --let $rpl_connection_name= server1
105 --source include/rpl_connection.inc
106 GRANT GROUP_REPLICATION_ADMIN ON *.* TO 'no_priv_user'@localhost;
107
108 --let $rpl_connection_name= no_priv_user_con
109 --source include/rpl_connection.inc
110 SET GLOBAL group_replication_consistency = @@GLOBAL.group_replication_consistency;
111
112 --echo
113 --echo ############################################################
114 --echo # 5. Clean up.
115
116 --disconnect no_priv_user_con
117 --let $count_vars=
118 --let $var_id=
119 --let $var_names=
120
121 --let $rpl_connection_name= server1
122 --source include/rpl_connection.inc
123
124 DROP TABLE gr_vars;
125 REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'no_priv_user'@localhost;
126 DROP USER 'no_priv_user'@localhost;
127 FLUSH PRIVILEGES;
128
129 --source include/group_replication_end.inc