Debian Codegraph @

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

raw
1 ###############################################################################
2 #
3 # The user must have GROUP_REPLICATION_ADMIN privileges to modify the
4 # group_replication_consistency option on GLOBAL scope
5 #
6 # Test:
7 # 0. One server is enough for this test
8 # 1. Create user with SYSTEM_VARIABLES_ADMIN privilege to allow change
9 # globals variables
10 # 2. Connect to server using group_rpl_user
11 # 3. Set group_replication_consistency at a global scope shall fail due
12 # to lack of privileges
13 # 4. Set group_replication_consistency at a session scope shall succeed,
14 # do not need extra privileges
15 # 5. Grant GROUP_REPLICATION_ADMIN privileges to group_rpl_user
16 # 6. Set group_replication_consistency at a global scope shall succeed
17 # 7. Cleanup
18 #
19 ###############################################################################
20
21 --source include/not_have_privilege_checks_user.inc
22 --source include/have_group_replication_plugin.inc
23 --let $rpl_skip_group_replication_start= 1
24 --source include/group_replication.inc
25 --source include/start_and_bootstrap_group_replication.inc
26
27 --echo
28 --echo # 1. Create user with SYSTEM_VARIABLES_ADMIN privilege to allow change
29 --echo # globals variables
30
31 CREATE USER 'group_rpl_user' IDENTIFIED BY '';
32 GRANT SYSTEM_VARIABLES_ADMIN ON *.* TO 'group_rpl_user';
33
34 --connect (con_group_rpl_user,127.0.0.1,group_rpl_user,,test,$MASTER_MYPORT,,)
35
36 --echo
37 --echo # 2. Connect to server using group_rpl_user
38
39 --let $rpl_connection_name= con_group_rpl_user
40 --source include/rpl_connection.inc
41
42 --echo
43 --echo # 3. Set group_replication_consistency at a global scope shall fail due
44 --echo # to lack of privileges
45
46 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
47 SET @@GLOBAL.group_replication_consistency= BEFORE_ON_PRIMARY_FAILOVER;
48
49 --echo
50 --echo # 4. Set group_replication_consistency at a session scope shall succeed,
51 --echo # do not need extra privileges
52
53 SET @@SESSION.group_replication_consistency= BEFORE_ON_PRIMARY_FAILOVER;
54
55 --echo
56 --echo # 5. Grant GROUP_REPLICATION_ADMIN privileges to group_rpl_user
57
58 --let $rpl_connection_name= default
59 --source include/rpl_connection.inc
60
61 GRANT GROUP_REPLICATION_ADMIN ON *.* TO 'group_rpl_user';
62
63 --echo
64 --echo # 6. Set group_replication_consistency at a global scope shall succeed
65
66 --let $rpl_connection_name= con_group_rpl_user
67 --source include/rpl_connection.inc
68
69 SET @@GLOBAL.group_replication_consistency= BEFORE_ON_PRIMARY_FAILOVER;
70
71 --echo
72 --echo # 7. Cleanup
73
74 --let $rpl_connection_name= default
75 --source include/rpl_connection.inc
76
77 SET @@GLOBAL.group_replication_consistency= DEFAULT;
78
79 --disconnect con_group_rpl_user
80 DROP USER group_rpl_user;
81
82 --source include/group_replication_end.inc