Debian Codegraph @

mysql-test/suite/sys_vars/t/table_encryption_privilege_check_basic.test

raw
1
2 --echo # This file contains test cases to validate the behavior of system
3 --echo # variable 'table_encryption_privilege_check' with various
4 --echo # permissions a user --echo # can have.
5
6 CREATE USER u1@localhost;
7 GRANT ALL ON db1.* TO u1@localhost;
8 connect (con1, localhost, u1);
9 SELECT CURRENT_USER();
10 SHOW GRANTS FOR CURRENT_USER();
11
12 --echo #
13 --echo # VARIABLE USED BY NORMAL USER.
14 --echo #
15
16 --echo #
17 --echo # SET table_encryption_privilege_check
18 --echo #
19
20 --error ER_GLOBAL_VARIABLE
21 SET SESSION table_encryption_privilege_check=true;
22
23 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
24 SET GLOBAL table_encryption_privilege_check=true;
25
26 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
27 SET PERSIST table_encryption_privilege_check=true;
28
29 --error ER_PERSIST_ONLY_ACCESS_DENIED_ERROR
30 SET PERSIST_ONLY table_encryption_privilege_check=true;
31
32 --echo #
33 --echo # VARIABLE USED BY USER WITH TABLE_ENCRYPTION_ADMIN privilege.
34 --echo #
35
36 connection default;
37 GRANT TABLE_ENCRYPTION_ADMIN ON *.* TO u1@localhost;
38 connection con1;
39 SELECT CURRENT_USER();
40 SHOW GRANTS FOR CURRENT_USER();
41
42 --echo #
43 --echo # SET table_encryption_privilege_check
44 --echo #
45
46 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
47 SET GLOBAL table_encryption_privilege_check=true;
48
49 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
50 SET PERSIST table_encryption_privilege_check=true;
51
52 --error ER_PERSIST_ONLY_ACCESS_DENIED_ERROR
53 SET PERSIST_ONLY table_encryption_privilege_check=true;
54
55 --echo #
56 --echo # VARIABLE USED BY USER WITH SYSTEM_VARIABLES_ADMIN privilege.
57 --echo #
58
59 connection default;
60 REVOKE TABLE_ENCRYPTION_ADMIN ON *.* FROM u1@localhost;
61 GRANT SYSTEM_VARIABLES_ADMIN ON *.* TO u1@localhost;
62 connection con1;
63 SELECT CURRENT_USER();
64 SHOW GRANTS FOR CURRENT_USER();
65
66 --echo #
67 --echo # SET table_encryption_privilege_check
68 --echo #
69
70 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
71 SET GLOBAL table_encryption_privilege_check=true;
72
73 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
74 SET PERSIST table_encryption_privilege_check=true;
75
76 --error ER_PERSIST_ONLY_ACCESS_DENIED_ERROR
77 SET PERSIST_ONLY table_encryption_privilege_check=true;
78
79 --echo #
80 --echo # VARIABLE USED BY USER WITH BOTH TABLE_ENCRYPTION_ADMIN and
81 --echo # SYSTEM_VARIABLES_ADMIN privilege.
82 --echo #
83
84 connection default;
85 GRANT TABLE_ENCRYPTION_ADMIN ON *.* TO u1@localhost;
86 connection con1;
87 SELECT CURRENT_USER();
88 SHOW GRANTS FOR CURRENT_USER();
89
90 --echo #
91 --echo # SET table_encryption_privilege_check
92 --echo #
93
94 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
95 SET GLOBAL table_encryption_privilege_check=true;
96
97 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
98 SET PERSIST table_encryption_privilege_check=true;
99
100 --error ER_PERSIST_ONLY_ACCESS_DENIED_ERROR
101 SET PERSIST_ONLY table_encryption_privilege_check=true;
102
103 --echo #
104 --echo # VARIABLE USED BY USER WITH PERSIST_RO_VARIABLES_ADMIN,
105 --echo # TABLE_ENCRYPTION_ADMIN && SYSTEM_VARIABLES_ADMIN privilege.
106 --echo #
107
108 connection default;
109 GRANT PERSIST_RO_VARIABLES_ADMIN ON *.* TO u1@localhost;
110 connection con1;
111 SELECT CURRENT_USER();
112 SHOW GRANTS FOR CURRENT_USER();
113
114 --echo #
115 --echo # SET table_encryption_privilege_check
116 --echo #
117
118 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
119 SET GLOBAL table_encryption_privilege_check=true;
120
121 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
122 SET PERSIST table_encryption_privilege_check=true;
123
124 SET PERSIST_ONLY table_encryption_privilege_check=true;
125 SELECT @@global.table_encryption_privilege_check = false;
126
127 --echo #
128 --echo # VARIABLE USED BY USER WITH SUPER privilege.
129 --echo #
130
131 connection default;
132 disconnect con1;
133 REVOKE TABLE_ENCRYPTION_ADMIN, SYSTEM_VARIABLES_ADMIN,
134 PERSIST_RO_VARIABLES_ADMIN ON *.* FROM u1@localhost;
135 GRANT SUPER ON *.* TO u1@localhost;
136 connect (con1, localhost, u1);
137 SELECT CURRENT_USER();
138 SHOW GRANTS FOR CURRENT_USER();
139
140 --echo #
141 --echo # SET table_encryption_privilege_check
142 --echo #
143
144 SET GLOBAL table_encryption_privilege_check=false;
145 SELECT @@global.table_encryption_privilege_check = false;
146
147 SET PERSIST table_encryption_privilege_check=true;
148 SELECT @@global.table_encryption_privilege_check = true;
149
150 --error ER_PERSIST_ONLY_ACCESS_DENIED_ERROR
151 SET PERSIST_ONLY table_encryption_privilege_check=true;
152
153 connection default;
154 disconnect con1;
155 REVOKE SUPER ON *.* FROM u1@localhost;
156 DROP USER u1@localhost;
157 RESET PERSIST;
158 SET GLOBAL table_encryption_privilege_check=default;