Debian Codegraph @

mysql-test/suite/auth_sec/r/grant_as_ddl.result

raw
1 SET @start_partial_revokes = @@global.partial_revokes;
2 SET @@global.partial_revokes=ON;
3 SET @@global.partial_revokes = ON;
4 SELECT @@global.partial_revokes;
5 @@global.partial_revokes
6 1
7 -------------------------------------------------------------------------
8 # 1. GRANT AS sanity checks
9 -------------------------------------------------------------------------
10 CREATE USER foo, bar, baz;
11 CREATE DATABASE db1;
12 CREATE TABLE db1.t1(c1 int);
13 GRANT SELECT ON db1.* TO foo AS bar;
14 ERROR HY000: GRANT ... AS is currently supported only for global privileges.
15 GRANT SELECT ON db1.t1 TO foo AS bar;
16 ERROR HY000: GRANT ... AS is currently supported only for global privileges.
17 GRANT SELECT(c1) ON db1.t1 TO foo AS bar;
18 ERROR HY000: GRANT ... AS is currently supported only for global privileges.
19 GRANT PROXY ON foo TO bar AS foo;
20 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS foo' at line 1
21 GRANT baz TO bar AS foo;
22 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS foo' at line 1
23 GRANT SELECT ON *.* TO bar WITH ROLE foo;
24 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ROLE foo' at line 1
25 GRANT SELECT ON *.* TO bar WITH ROLE NONE;
26 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ROLE NONE' at line 1
27 GRANT SELECT ON *.* TO bar WITH ROLE ALL;
28 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ROLE ALL' at line 1
29 GRANT SELECT ON *.* TO bar WITH ROLE DEFAULT;
30 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ROLE DEFAULT' at line 1
31 GRANT SELECT ON *.* TO foo AS hohoho;
32 ERROR HY000: Either some of the authorization IDs in the AS clause are invalid or the current user lacks privileges to execute the statement.
33 GRANT SELECT ON *.* TO foo AS bar WITH ROLE hohoho;
34 ERROR HY000: Either some of the authorization IDs in the AS clause are invalid or the current user lacks privileges to execute the statement.
35 GRANT SELECT ON *.* TO foo AS bar WITH ROLE baz, hohoho;
36 ERROR HY000: Either some of the authorization IDs in the AS clause are invalid or the current user lacks privileges to execute the statement.
37 DROP TABLE db1.t1;
38 DROP DATABASE db1;
39 DROP USER foo, bar, baz;
40 -------------------------------------------------------------------------
41 # 2. Permission checks
42 -------------------------------------------------------------------------
43 CREATE USER foo, bar;
44 CREATE ROLE baz, qux;
45 CREATE DATABASE db1;
46 GRANT SELECT ON *.* TO foo AS bar WITH ROLE baz;
47 ERROR HY000: Either some of the authorization IDs in the AS clause are invalid or the current user lacks privileges to execute the statement.
48 GRANT SELECT ON *.* TO foo AS `root`@`localhost`;
49 GRANT SELECT ON *.* TO foo WITH GRANT OPTION;
50 REVOKE SELECT ON db1.* FROM foo;
51 GRANT SELECT ON *.* TO bar AS `root`@`localhost`;
52 ERROR HY000: Either some of the authorization IDs in the AS clause are invalid or the current user lacks privileges to execute the statement.
53 GRANT SYSTEM_USER ON *.* TO foo;
54 GRANT SELECT ON *.* TO bar AS `root`@`localhost`;
55 ERROR HY000: Either some of the authorization IDs in the AS clause are invalid or the current user lacks privileges to execute the statement.
56 REVOKE ALL ON *.* FROM foo;
57 GRANT SYSTEM_USER ON *.* TO foo;
58 GRANT INSERT ON *.* TO foo WITH GRANT OPTION;
59 GRANT SELECT ON *.* TO baz WITH GRANT OPTION;
60 GRANT SELECT ON db1.* to qux;
61 GRANT baz, qux TO foo;
62 SET ROLE baz;
63 GRANT SELECT ON *.* TO bar AS `root`@`localhost`;
64 SET ROLE qux;
65 GRANT SELECT ON *.* TO bar;
66 ERROR 28000: Access denied for user 'foo'@'%' (using password: NO)
67 DROP DATABASE db1;
68 DROP ROLE baz, qux;
69 DROP USER foo, bar;
70 CREATE USER foo, bar, baz;
71 CREATE ROLE r1, r2, r3;
72 GRANT SELECT ON *.* TO foo WITH GRANT OPTION;
73 GRANT SYSTEM_USER ON *.* TO r2;
74 GRANT r2 TO r3;
75 GRANT r1, r3 TO bar;
76 GRANT SELECT ON *.* TO baz AS bar;
77 GRANT SELECT ON *.* TO baz AS bar WITH ROLE NONE;
78 GRANT SELECT ON *.* TO baz AS bar WITH ROLE r1;
79 GRANT SELECT ON *.* TO baz AS bar WITH ROLE r2;
80 ERROR HY000: Either some of the authorization IDs in the AS clause are invalid or the current user lacks privileges to execute the statement.
81 GRANT SELECT ON *.* TO baz AS bar WITH ROLE r1, r2;
82 ERROR HY000: Either some of the authorization IDs in the AS clause are invalid or the current user lacks privileges to execute the statement.
83 GRANT SELECT ON *.* TO baz AS bar WITH ROLE ALL;
84 SHOW GRANTS FOR baz;
85 Grants for baz@%
86 GRANT SELECT ON *.* TO `baz`@`%`
87 DROP ROLE r1, r2, r3;
88 DROP USER foo, bar, baz;
89 -------------------------------------------------------------------------
90 # 3. User test
91 -------------------------------------------------------------------------
92 CREATE USER foo, bar;
93 CREATE DATABASE db1;
94 GRANT SELECT, INSERT ON *.* TO bar AS CURRENT_USER();
95 SHOW GRANTS FOR bar;
96 Grants for bar@%
97 GRANT SELECT, INSERT ON *.* TO `bar`@`%`
98 REVOKE ALL ON *.* FROM bar;
99 GRANT SELECT ON *.* TO bar AS foo;
100 SHOW GRANTS FOR bar;
101 Grants for bar@%
102 GRANT SELECT ON *.* TO `bar`@`%`
103 REVOKE ALL ON *.* FROM bar;
104 GRANT SELECT ON *.* TO foo;
105 REVOKE SELECT ON db1.* FROM foo;
106 GRANT SELECT ON *.* TO bar AS foo;
107 SHOW GRANTS FOR bar;
108 Grants for bar@%
109 GRANT SELECT ON *.* TO `bar`@`%`
110 REVOKE SELECT ON `db1`.* FROM `bar`@`%`
111 REVOKE ALL ON *.* FROM bar;
112 GRANT SELECT, INSERT ON *.* TO bar AS foo;
113 SHOW GRANTS FOR bar;
114 Grants for bar@%
115 GRANT SELECT, INSERT ON *.* TO `bar`@`%`
116 REVOKE SELECT ON `db1`.* FROM `bar`@`%`
117 DROP DATABASE db1;
118 DROP USER foo, bar;
119 -------------------------------------------------------------------------
120 # 4. Roles test
121 -------------------------------------------------------------------------
122 CREATE USER foo, bar;
123 CREATE ROLE r1, r2, r3, r4;
124 CREATE DATABASE db1;
125 GRANT SELECT ON *.* TO r1;
126 REVOKE SELECT ON db1.* FROM r1;
127 GRANT r1 TO r2;
128 GRANT INSERT ON *.* TO r3;
129 REVOKE INSERT ON db1.* FROM r3;
130 GRANT r3 TO r4;
131 GRANT r2, r4 TO foo;
132 GRANT SELECT, INSERT ON *.* TO bar AS foo WITH ROLE ALL;
133 SHOW GRANTS FOR bar;
134 Grants for bar@%
135 GRANT SELECT, INSERT ON *.* TO `bar`@`%`
136 REVOKE SELECT, INSERT ON `db1`.* FROM `bar`@`%`
137 REVOKE ALL ON *.* FROM bar;
138 ALTER USER foo DEFAULT ROLE ALL;
139 GRANT SELECT, INSERT ON *.* TO bar AS foo WITH ROLE ALL;
140 SHOW GRANTS FOR bar;
141 Grants for bar@%
142 GRANT SELECT, INSERT ON *.* TO `bar`@`%`
143 REVOKE SELECT, INSERT ON `db1`.* FROM `bar`@`%`
144 REVOKE ALL ON *.* FROM bar;
145 GRANT SELECT, INSERT ON *.* TO bar AS foo WITH ROLE ALL EXCEPT r4;
146 SHOW GRANTS FOR bar;
147 Grants for bar@%
148 GRANT SELECT, INSERT ON *.* TO `bar`@`%`
149 REVOKE SELECT ON `db1`.* FROM `bar`@`%`
150 REVOKE ALL ON *.* FROM bar;
151 ALTER USER foo DEFAULT ROLE ALL;
152 GRANT SELECT, INSERT ON *.* TO bar AS foo WITH ROLE r2, r4;
153 SHOW GRANTS FOR bar;
154 Grants for bar@%
155 GRANT SELECT, INSERT ON *.* TO `bar`@`%`
156 REVOKE SELECT, INSERT ON `db1`.* FROM `bar`@`%`
157 DROP DATABASE db1;
158 DROP ROLE r1, r2, r3, r4;
159 DROP USER foo, bar;
160 -------------------------------------------------------------------------
161 # 6. Without --partial_revokes
162 -------------------------------------------------------------------------
163 SET @save_partial_revokes = @@global.partial_revokes;
164 SET @@global.partial_revokes = OFF;
165 CREATE USER foo, bar;
166 CREATE ROLE r1, r2;
167 GRANT r1, r2 TO foo;
168 ALTER USER foo DEFAULT ROLE ALL;
169 GRANT SELECT, INSERT ON *.* TO bar AS foo;
170 GRANT SELECT, INSERT ON *.* TO bar AS foo WITH ROLE NONE;
171 GRANT SELECT, INSERT ON *.* TO bar AS foo WITH ROLE ALL;
172 GRANT SELECT, INSERT ON *.* TO bar AS foo WITH ROLE ALL EXCEPT r1;
173 GRANT SELECT, INSERT ON *.* TO bar AS foo WITH ROLE DEFAULT;
174 DROP USER foo, bar;
175 DROP ROLE r1, r2;
176 SET @@global.partial_revokes = @save_partial_revokes;
177 -------------------------------------------------------------------------
178 # 7. Binlog tests
179 -------------------------------------------------------------------------
180 CREATE USER foo, bar;
181 CREATE ROLE r1, r2, r3, r4;
182 CREATE DATABASE db1;
183 GRANT SELECT ON *.* TO r1 WITH GRANT OPTION;
184 REVOKE SELECT ON db1.* FROM r1;
185 GRANT r1 TO r2;
186 GRANT INSERT ON *.* TO r3 WITH GRANT OPTION;
187 REVOKE INSERT ON db1.* FROM r3;
188 GRANT r3 TO r4;
189 GRANT r2, r4 TO foo;
190 ALTER USER foo DEFAULT ROLE ALL;
191 include/save_binlog_position.inc
192 GRANT SELECT, INSERT ON *.* TO bar AS foo WITH ROLE ALL;
193 GRANT SELECT, INSERT ON *.* TO bar AS foo WITH ROLE NONE;
194 GRANT SELECT, INSERT ON *.* TO bar AS foo WITH ROLE ALL EXCEPT r2;
195 GRANT SELECT, INSERT ON *.* TO bar AS foo WITH ROLE DEFAULT;
196 GRANT SELECT, INSERT ON *.* TO bar AS foo WITH ROLE r2, r4;
197 GRANT SELECT, INSERT ON *.* TO bar AS CURRENT_USER();
198 GRANT SELECT, INSERT ON *.* TO bar AS CURRENT_USER() WITH ROLE ALL;
199 GRANT SELECT, INSERT ON *.* TO bar AS CURRENT_USER() WITH ROLE NONE;
200 GRANT SELECT, INSERT ON *.* TO bar AS CURRENT_USER() WITH ROLE DEFAULT;
201 GRANT SELECT, INSERT ON *.* TO foo AS foo WITH ROLE ALL;
202 GRANT SELECT, INSERT ON *.* TO foo AS foo WITH ROLE NONE;
203 GRANT SELECT, INSERT ON *.* TO foo AS foo WITH ROLE ALL EXCEPT r2;
204 GRANT SELECT, INSERT ON *.* TO foo AS foo WITH ROLE DEFAULT;
205 GRANT SELECT, INSERT ON *.* TO foo AS foo WITH ROLE r2, r4;
206 GRANT SELECT, INSERT ON *.* TO bar;
207 include/show_binlog_events.inc
208 Log_name Pos Event_type Server_id End_log_pos Info
209 binlog.000001 # Query # # use `test`; GRANT SELECT, INSERT ON *.* TO 'bar'@'%' AS 'foo'@'%' WITH ROLE ALL
210 binlog.000001 # Query # # use `test`; GRANT SELECT, INSERT ON *.* TO 'bar'@'%' AS 'foo'@'%' WITH ROLE NONE
211 binlog.000001 # Query # # use `test`; GRANT SELECT, INSERT ON *.* TO 'bar'@'%' AS 'foo'@'%' WITH ROLE ALL EXCEPT 'r2'@'%'
212 binlog.000001 # Query # # use `test`; GRANT SELECT, INSERT ON *.* TO 'bar'@'%' AS 'foo'@'%' WITH ROLE DEFAULT
213 binlog.000001 # Query # # use `test`; GRANT SELECT, INSERT ON *.* TO 'bar'@'%' AS 'foo'@'%' WITH ROLE 'r2'@'%','r4'@'%'
214 binlog.000001 # Query # # use `test`; GRANT SELECT, INSERT ON *.* TO 'bar'@'%' AS 'root'@'localhost' WITH ROLE NONE
215 binlog.000001 # Query # # use `test`; GRANT SELECT, INSERT ON *.* TO 'bar'@'%' AS 'root'@'localhost' WITH ROLE ALL
216 binlog.000001 # Query # # use `test`; GRANT SELECT, INSERT ON *.* TO 'bar'@'%' AS 'root'@'localhost' WITH ROLE NONE
217 binlog.000001 # Query # # use `test`; GRANT SELECT, INSERT ON *.* TO 'bar'@'%' AS 'root'@'localhost' WITH ROLE DEFAULT
218 binlog.000001 # Query # # use `test`; GRANT SELECT, INSERT ON *.* TO 'foo'@'%' AS 'foo'@'%' WITH ROLE ALL
219 binlog.000001 # Query # # use `test`; GRANT SELECT, INSERT ON *.* TO 'foo'@'%' AS 'foo'@'%' WITH ROLE NONE
220 binlog.000001 # Query # # use `test`; GRANT SELECT, INSERT ON *.* TO 'foo'@'%' AS 'foo'@'%' WITH ROLE ALL EXCEPT 'r2'@'%'
221 binlog.000001 # Query # # use `test`; GRANT SELECT, INSERT ON *.* TO 'foo'@'%' AS 'foo'@'%' WITH ROLE DEFAULT
222 binlog.000001 # Query # # use `test`; GRANT SELECT, INSERT ON *.* TO 'foo'@'%' AS 'foo'@'%' WITH ROLE 'r2'@'%','r4'@'%'
223 binlog.000001 # Query # # use `test`; GRANT SELECT, INSERT ON *.* TO 'bar'@'%' AS 'foo'@'%' WITH ROLE 'r2'@'%','r4'@'%'
224 GRANT SELECT, INSERT ON *.* TO foo;
225 REVOKE SELECT, INSERT ON db1.* FROM foo;
226 include/save_binlog_position.inc
227 GRANT SELECT, INSERT ON *.* TO bar AS foo;
228 include/show_binlog_events.inc
229 Log_name Pos Event_type Server_id End_log_pos Info
230 binlog.000001 # Query # # use `test`; GRANT SELECT, INSERT ON *.* TO 'bar'@'%' AS 'foo'@'%' WITH ROLE NONE
231 DROP DATABASE db1;
232 DROP ROLE r1, r2, r3, r4;
233 DROP USER foo, bar;
234 -------------------------------------------------------------------------
235 # 8. Current user in AS caluse
236 -------------------------------------------------------------------------
237 CREATE USER foo, bar, baz;
238 CREATE ROLE r1, r2;
239 GRANT SELECT, INSERT ON *.* TO r1 WITH GRANT OPTION;
240 REVOKE SELECT ON mysql.* FROM r1;
241 GRANT SELECT, INSERT ON *.* TO r2 WITH GRANT OPTION;
242 REVOKE INSERT ON mysql.* FROM r2;
243 GRANT r1, r2 TO foo;
244 ALTER USER foo DEFAULT ROLE ALL;
245 GRANT SELECT ON *.* TO bar AS current_user() WITH ROLE r1;
246 GRANT INSERT ON *.* TO baz AS foo WITH ROLE r2;
247 SHOW GRANTS FOR bar;
248 Grants for bar@%
249 GRANT SELECT ON *.* TO `bar`@`%`
250 REVOKE SELECT ON `mysql`.* FROM `bar`@`%`
251 SHOW GRANTS FOR baz;
252 Grants for baz@%
253 GRANT INSERT ON *.* TO `baz`@`%`
254 REVOKE INSERT ON `mysql`.* FROM `baz`@`%`
255 DROP ROLE r1, r2;
256 DROP USER foo, bar, baz;
257 CREATE USER foo, bar;
258 CREATE ROLE r1, r2;
259 GRANT r1, r2 TO foo;
260 GRANT SELECT ON *.* TO r1 WITH GRANT OPTION;
261 REVOKE SELECT ON mysql.* FROM r1;
262 GRANT INSERT ON *.* TO r2 WITH GRANT OPTION;
263 REVOKE INSERT ON mysql.* FROM r2;
264 ALTER USER foo DEFAULT ROLE ALL;
265 GRANT SELECT, INSERT ON *.* TO bar AS current_user();
266 ERROR HY000: Either some of the authorization IDs in the AS clause are invalid or the current user lacks privileges to execute the statement.
267 GRANT SELECT, INSERT ON *.* TO bar AS current_user() WITH ROLE r1;
268 ERROR HY000: Either some of the authorization IDs in the AS clause are invalid or the current user lacks privileges to execute the statement.
269 GRANT SELECT, INSERT ON *.* TO bar AS current_user() WITH ROLE r2;
270 ERROR HY000: Either some of the authorization IDs in the AS clause are invalid or the current user lacks privileges to execute the statement.
271 GRANT SELECT, INSERT ON *.* TO bar AS foo;
272 ERROR HY000: Either some of the authorization IDs in the AS clause are invalid or the current user lacks privileges to execute the statement.
273 GRANT SELECT, INSERT ON *.* TO bar AS foo WITH ROLE r1;
274 ERROR HY000: Either some of the authorization IDs in the AS clause are invalid or the current user lacks privileges to execute the statement.
275 GRANT SELECT, INSERT ON *.* TO bar AS foo WITH ROLE r2;
276 ERROR HY000: Either some of the authorization IDs in the AS clause are invalid or the current user lacks privileges to execute the statement.
277 DROP ROLE r1, r2;
278 DROP USER foo, bar;
279 -------------------------------------------------------------------------
280 # 9. General log
281 -------------------------------------------------------------------------
282 SET @save_partial_revokes = @@global.partial_revokes;
283 CREATE USER u1, u2;
284 CREATE ROLE r1, r2;
285 GRANT r1, r2 TO u1;
286 GRANT SELECT ON *.* TO r1 WITH GRANT OPTION;
287 GRANT INSERT ON *.* TO r2 WITH GRANT OPTION;
288 ALTER USER u1 DEFAULT ROLE ALL;
289 TRUNCATE TABLE mysql.general_log;
290 SET @old_log_output= @@global.log_output;
291 SET @old_general_log= @@global.general_log;
292 SET @old_general_log_file= @@global.general_log_file;
293 SET GLOBAL general_log_file = 'MYSQLTEST_VARDIR/log/grant_as_ddl_general.log';
294 SET GLOBAL log_output = 'FILE,TABLE';
295 SET GLOBAL general_log= 'ON';
296 SET @@global.partial_revokes = ON;
297 REVOKE SELECT ON mysql.* FROM r1;
298 REVOKE INSERT ON mysql.* FROM r2;
299 GRANT SELECT, INSERT ON *.* TO u2;
300 GRANT SELECT, INSERT ON *.* TO u2 AS u1;
301 GRANT SELECT, INSERT ON *.* TO u2 AS u1 WITH ROLE NONE;
302 GRANT SELECT, INSERT ON *.* TO u2 AS u1 WITH ROLE DEFAULT;
303 GRANT SELECT, INSERT ON *.* TO u2 AS u1 WITH ROLE ALL;
304 GRANT SELECT, INSERT ON *.* TO u2 AS u1 WITH ROLE ALL EXCEPT r1;
305 SET ROLE NONE;
306 SET ROLE r1;
307 GRANT SELECT ON *.* TO u2;
308 SET ROLE r1, r2;
309 GRANT SELECT, INSERT ON *.* TO u2;
310 SET ROLE ALL;
311 GRANT SELECT, INSERT ON *.* TO u2;
312 SET ROLE DEFAULT;
313 GRANT SELECT, INSERT ON *.* TO u2;
314 GRANT SELECT ON *.* TO u2 AS u1 WITH ROLE r1;
315 GRANT SELECT ON *.* TO u2 AS u1 WITH ROLE ALL;
316 GRANT SELECT ON *.* TO u2 AS u1 WITH ROLE DEFAULT;
317 GRANT SELECT ON *.* TO u2 AS u1 WITH ROLE ALL EXCEPT r2;
318 SET ROLE NONE;
319 GRANT SELECT ON *.* TO r1;
320 GRANT INSERT ON *.* TO r2;
321 SET @@global.partial_revokes = OFF;
322 GRANT SELECT, INSERT ON *.* TO u2;
323 GRANT SELECT, INSERT ON *.* TO u2 AS u1;
324 GRANT SELECT, INSERT ON *.* TO u2 AS u1 WITH ROLE NONE;
325 GRANT SELECT, INSERT ON *.* TO u2 AS u1 WITH ROLE DEFAULT;
326 GRANT SELECT, INSERT ON *.* TO u2 AS u1 WITH ROLE ALL;
327 GRANT SELECT, INSERT ON *.* TO u2 AS u1 WITH ROLE ALL EXCEPT r1;
328 SET ROLE NONE;
329 SET ROLE r1;
330 GRANT SELECT ON *.* TO u2;
331 SET ROLE r1, r2;
332 GRANT SELECT, INSERT ON *.* TO u2;
333 SET ROLE ALL;
334 GRANT SELECT, INSERT ON *.* TO u2;
335 SET ROLE DEFAULT;
336 GRANT SELECT, INSERT ON *.* TO u2;
337 GRANT SELECT ON *.* TO u2 AS u1 WITH ROLE r1;
338 GRANT SELECT ON *.* TO u2 AS u1 WITH ROLE ALL;
339 GRANT SELECT ON *.* TO u2 AS u1 WITH ROLE DEFAULT;
340 GRANT SELECT ON *.* TO u2 AS u1 WITH ROLE ALL EXCEPT r2;
341 SET ROLE NONE;
342 DROP ROLE r1, r2;
343 DROP USER u1, u2;
344 SET @@global.partial_revokes = @save_partial_revokes;
345 Show what is logged:
346 ------ rewrite ------
347 SELECT COUNT(*) = 8 AS NO_AS_CLAUSE_COUNT FROM mysql.general_log WHERE argument LIKE 'GRANT SELECT, INSERT ON *.* TO u2' AND command_type NOT LIKE 'Prepare';
348 NO_AS_CLAUSE_COUNT
349 1
350 SELECT COUNT(*) = 2 AS WITH_AS_WITHOUT_ROLE_COUNT FROM mysql.general_log WHERE argument LIKE 'GRANT SELECT, INSERT ON *.* TO u2 AS u1' AND command_type NOT LIKE 'Prepare';
351 WITH_AS_WITHOUT_ROLE_COUNT
352 1
353 SELECT COUNT(*) = 2 AS WITH_AS_WITH_ROLE_NONE_COUNT FROM mysql.general_log WHERE argument LIKE 'GRANT SELECT, INSERT ON *.* TO u2 AS u1 WITH ROLE NONE' AND command_type NOT LIKE 'Prepare';
354 WITH_AS_WITH_ROLE_NONE_COUNT
355 1
356 SELECT COUNT(*) = 2 AS WITH_AS_WITH_ROLE_DEFAULT_COUNT FROM mysql.general_log WHERE argument LIKE 'GRANT SELECT, INSERT ON *.* TO u2 AS u1 WITH ROLE DEFAULT' AND command_type NOT LIKE 'Prepare';
357 WITH_AS_WITH_ROLE_DEFAULT_COUNT
358 1
359 SELECT COUNT(*) = 2 AS WITH_AS_WITH_ROLE_ALL_COUNT FROM mysql.general_log WHERE argument LIKE 'GRANT SELECT, INSERT ON *.* TO u2 AS u1 WITH ROLE ALL' AND command_type NOT LIKE 'Prepare';
360 WITH_AS_WITH_ROLE_ALL_COUNT
361 1
362 SELECT COUNT(*) = 2 AS WITH_AS_WITH_ROLE_ALL_EXCEPT_COUNT FROM mysql.general_log WHERE argument LIKE 'GRANT SELECT, INSERT ON *.* TO u2 AS u1 WITH ROLE ALL EXCEPT r1' AND command_type NOT LIKE 'Prepare';
363 WITH_AS_WITH_ROLE_ALL_EXCEPT_COUNT
364 1
365 ------ done ------
366 SET GLOBAL general_log_file= @old_general_log_file;
367 SET GLOBAL general_log= @old_general_log;
368 SET GLOBAL log_output= @old_log_output;
369 TRUNCATE TABLE mysql.general_log;
370 -------------------------------------------------------------------------
371 SET @@global.partial_revokes = @start_partial_revokes;