Debian Codegraph @

mysql-test/suite/roles/recursive_dbug.result

raw
1 show status like 'debug%';
2 Variable_name Value
3 set @old_dbug=@@global.debug_dbug;
4 set global debug_dbug="+d,role_merge_stats";
5 create user foo@localhost;
6 grant select on test.* to foo@localhost;
7 create role role1;
8 create role role2;
9 create role role3;
10 create role role4;
11 create role role5;
12 create role role6;
13 create role role7;
14 create role role8;
15 create role role9;
16 create role role10;
17 grant role1 to role2;
18 grant role2 to role4;
19 grant role2 to role5;
20 grant role3 to role5;
21 grant role4 to role6;
22 grant role5 to role6;
23 grant role5 to role7;
24 grant role6 to role8;
25 grant role6 to role9;
26 grant role7 to role9;
27 grant role9 to role10;
28 grant role10 to foo@localhost;
29 grant role10 to role2;
30 ERROR HY000: Cannot grant role 'role10' to: 'role2'
31 connect foo, localhost, foo;
32 show grants;
33 Grants for foo@localhost
34 GRANT SELECT ON `test`.* TO `foo`@`localhost`
35 GRANT USAGE ON *.* TO `foo`@`localhost`
36 GRANT `role10` TO `foo`@`localhost`
37 select * from information_schema.applicable_roles;
38 GRANTEE ROLE_NAME IS_GRANTABLE IS_DEFAULT
39 foo@localhost role10 NO NO
40 role10 role9 NO NULL
41 role2 role1 NO NULL
42 role4 role2 NO NULL
43 role5 role2 NO NULL
44 role5 role3 NO NULL
45 role6 role4 NO NULL
46 role6 role5 NO NULL
47 role7 role5 NO NULL
48 role9 role6 NO NULL
49 role9 role7 NO NULL
50 show status like 'debug%';
51 Variable_name Value
52 Debug_role_merges_global 11
53 Debug_role_merges_db 0
54 Debug_role_merges_table 0
55 Debug_role_merges_column 0
56 Debug_role_merges_routine 0
57 connection default;
58 grant select on *.* to role1;
59 show status like 'debug%';
60 Variable_name Value
61 Debug_role_merges_global 20
62 Debug_role_merges_db 0
63 Debug_role_merges_table 0
64 Debug_role_merges_column 0
65 Debug_role_merges_routine 0
66 connection foo;
67 select count(*) from mysql.roles_mapping;
68 ERROR 42000: SELECT command denied to user 'foo'@'localhost' for table `mysql`.`roles_mapping`
69 set role role10;
70 select count(*) from mysql.roles_mapping;
71 count(*)
72 22
73 show grants;
74 Grants for foo@localhost
75 GRANT SELECT ON *.* TO `role1`
76 GRANT SELECT ON `test`.* TO `foo`@`localhost`
77 GRANT USAGE ON *.* TO `foo`@`localhost`
78 GRANT USAGE ON *.* TO `role10`
79 GRANT USAGE ON *.* TO `role2`
80 GRANT USAGE ON *.* TO `role3`
81 GRANT USAGE ON *.* TO `role4`
82 GRANT USAGE ON *.* TO `role5`
83 GRANT USAGE ON *.* TO `role6`
84 GRANT USAGE ON *.* TO `role7`
85 GRANT USAGE ON *.* TO `role9`
86 GRANT `role10` TO `foo`@`localhost`
87 GRANT `role1` TO `role2`
88 GRANT `role2` TO `role4`
89 GRANT `role2` TO `role5`
90 GRANT `role3` TO `role5`
91 GRANT `role4` TO `role6`
92 GRANT `role5` TO `role6`
93 GRANT `role5` TO `role7`
94 GRANT `role6` TO `role9`
95 GRANT `role7` TO `role9`
96 GRANT `role9` TO `role10`
97 select * from information_schema.enabled_roles;
98 ROLE_NAME
99 role1
100 role10
101 role2
102 role3
103 role4
104 role5
105 role6
106 role7
107 role9
108 connection default;
109 revoke select on *.* from role1;
110 show status like 'debug%';
111 Variable_name Value
112 Debug_role_merges_global 29
113 Debug_role_merges_db 0
114 Debug_role_merges_table 0
115 Debug_role_merges_column 0
116 Debug_role_merges_routine 0
117 connection foo;
118 select count(*) from mysql.roles_mapping;
119 count(*)
120 22
121 set role none;
122 set role role10;
123 select count(*) from mysql.roles_mapping;
124 ERROR 42000: SELECT command denied to user 'foo'@'localhost' for table `mysql`.`roles_mapping`
125 set role none;
126 connection default;
127 grant select on mysql.* to role1;
128 show status like 'debug%';
129 Variable_name Value
130 Debug_role_merges_global 29
131 Debug_role_merges_db 9
132 Debug_role_merges_table 0
133 Debug_role_merges_column 0
134 Debug_role_merges_routine 0
135 connection foo;
136 select count(*) from mysql.roles_mapping;
137 ERROR 42000: SELECT command denied to user 'foo'@'localhost' for table `mysql`.`roles_mapping`
138 set role role10;
139 select count(*) from mysql.roles_mapping;
140 count(*)
141 22
142 show grants;
143 Grants for foo@localhost
144 GRANT SELECT ON `mysql`.* TO `role1`
145 GRANT SELECT ON `test`.* TO `foo`@`localhost`
146 GRANT USAGE ON *.* TO `foo`@`localhost`
147 GRANT USAGE ON *.* TO `role10`
148 GRANT USAGE ON *.* TO `role1`
149 GRANT USAGE ON *.* TO `role2`
150 GRANT USAGE ON *.* TO `role3`
151 GRANT USAGE ON *.* TO `role4`
152 GRANT USAGE ON *.* TO `role5`
153 GRANT USAGE ON *.* TO `role6`
154 GRANT USAGE ON *.* TO `role7`
155 GRANT USAGE ON *.* TO `role9`
156 GRANT `role10` TO `foo`@`localhost`
157 GRANT `role1` TO `role2`
158 GRANT `role2` TO `role4`
159 GRANT `role2` TO `role5`
160 GRANT `role3` TO `role5`
161 GRANT `role4` TO `role6`
162 GRANT `role5` TO `role6`
163 GRANT `role5` TO `role7`
164 GRANT `role6` TO `role9`
165 GRANT `role7` TO `role9`
166 GRANT `role9` TO `role10`
167 connection default;
168 revoke select on mysql.* from role1;
169 show status like 'debug%';
170 Variable_name Value
171 Debug_role_merges_global 29
172 Debug_role_merges_db 17
173 Debug_role_merges_table 0
174 Debug_role_merges_column 0
175 Debug_role_merges_routine 0
176 connection foo;
177 select count(*) from mysql.roles_mapping;
178 ERROR 42000: SELECT command denied to user 'foo'@'localhost' for table `mysql`.`roles_mapping`
179 set role none;
180 connection default;
181 grant select on mysql.roles_mapping to role1;
182 show status like 'debug%';
183 Variable_name Value
184 Debug_role_merges_global 29
185 Debug_role_merges_db 17
186 Debug_role_merges_table 9
187 Debug_role_merges_column 0
188 Debug_role_merges_routine 0
189 connection foo;
190 select count(*) from mysql.roles_mapping;
191 ERROR 42000: SELECT command denied to user 'foo'@'localhost' for table `mysql`.`roles_mapping`
192 set role role10;
193 select count(*) from mysql.roles_mapping;
194 count(*)
195 22
196 show grants;
197 Grants for foo@localhost
198 GRANT SELECT ON `mysql`.`roles_mapping` TO `role1`
199 GRANT SELECT ON `test`.* TO `foo`@`localhost`
200 GRANT USAGE ON *.* TO `foo`@`localhost`
201 GRANT USAGE ON *.* TO `role10`
202 GRANT USAGE ON *.* TO `role1`
203 GRANT USAGE ON *.* TO `role2`
204 GRANT USAGE ON *.* TO `role3`
205 GRANT USAGE ON *.* TO `role4`
206 GRANT USAGE ON *.* TO `role5`
207 GRANT USAGE ON *.* TO `role6`
208 GRANT USAGE ON *.* TO `role7`
209 GRANT USAGE ON *.* TO `role9`
210 GRANT `role10` TO `foo`@`localhost`
211 GRANT `role1` TO `role2`
212 GRANT `role2` TO `role4`
213 GRANT `role2` TO `role5`
214 GRANT `role3` TO `role5`
215 GRANT `role4` TO `role6`
216 GRANT `role5` TO `role6`
217 GRANT `role5` TO `role7`
218 GRANT `role6` TO `role9`
219 GRANT `role7` TO `role9`
220 GRANT `role9` TO `role10`
221 connection default;
222 revoke select on mysql.roles_mapping from role1;
223 show status like 'debug%';
224 Variable_name Value
225 Debug_role_merges_global 29
226 Debug_role_merges_db 17
227 Debug_role_merges_table 17
228 Debug_role_merges_column 0
229 Debug_role_merges_routine 0
230 connection foo;
231 select count(*) from mysql.roles_mapping;
232 ERROR 42000: SELECT command denied to user 'foo'@'localhost' for table `mysql`.`roles_mapping`
233 set role none;
234 connection default;
235 grant select(User) on mysql.roles_mapping to role1;
236 show status like 'debug%';
237 Variable_name Value
238 Debug_role_merges_global 29
239 Debug_role_merges_db 17
240 Debug_role_merges_table 26
241 Debug_role_merges_column 9
242 Debug_role_merges_routine 0
243 connection foo;
244 select count(*) from mysql.roles_mapping;
245 ERROR 42000: SELECT command denied to user 'foo'@'localhost' for table `mysql`.`roles_mapping`
246 set role role10;
247 select count(concat(User,Host,Role)) from mysql.roles_mapping;
248 ERROR 42000: SELECT command denied to user 'foo'@'localhost' for column 'Host' in table 'roles_mapping'
249 select count(concat(User)) from mysql.roles_mapping;
250 count(concat(User))
251 22
252 show grants;
253 Grants for foo@localhost
254 GRANT SELECT (`User`) ON `mysql`.`roles_mapping` TO `role1`
255 GRANT SELECT ON `test`.* TO `foo`@`localhost`
256 GRANT USAGE ON *.* TO `foo`@`localhost`
257 GRANT USAGE ON *.* TO `role10`
258 GRANT USAGE ON *.* TO `role1`
259 GRANT USAGE ON *.* TO `role2`
260 GRANT USAGE ON *.* TO `role3`
261 GRANT USAGE ON *.* TO `role4`
262 GRANT USAGE ON *.* TO `role5`
263 GRANT USAGE ON *.* TO `role6`
264 GRANT USAGE ON *.* TO `role7`
265 GRANT USAGE ON *.* TO `role9`
266 GRANT `role10` TO `foo`@`localhost`
267 GRANT `role1` TO `role2`
268 GRANT `role2` TO `role4`
269 GRANT `role2` TO `role5`
270 GRANT `role3` TO `role5`
271 GRANT `role4` TO `role6`
272 GRANT `role5` TO `role6`
273 GRANT `role5` TO `role7`
274 GRANT `role6` TO `role9`
275 GRANT `role7` TO `role9`
276 GRANT `role9` TO `role10`
277 connection default;
278 grant select(Host) on mysql.roles_mapping to role3;
279 show status like 'debug%';
280 Variable_name Value
281 Debug_role_merges_global 29
282 Debug_role_merges_db 17
283 Debug_role_merges_table 33
284 Debug_role_merges_column 16
285 Debug_role_merges_routine 0
286 connection foo;
287 select count(concat(User,Host,Role)) from mysql.roles_mapping;
288 ERROR 42000: SELECT command denied to user 'foo'@'localhost' for column 'Role' in table 'roles_mapping'
289 select count(concat(User,Host)) from mysql.roles_mapping;
290 count(concat(User,Host))
291 22
292 show grants;
293 Grants for foo@localhost
294 GRANT SELECT (`Host`) ON `mysql`.`roles_mapping` TO `role3`
295 GRANT SELECT (`User`) ON `mysql`.`roles_mapping` TO `role1`
296 GRANT SELECT ON `test`.* TO `foo`@`localhost`
297 GRANT USAGE ON *.* TO `foo`@`localhost`
298 GRANT USAGE ON *.* TO `role10`
299 GRANT USAGE ON *.* TO `role1`
300 GRANT USAGE ON *.* TO `role2`
301 GRANT USAGE ON *.* TO `role3`
302 GRANT USAGE ON *.* TO `role4`
303 GRANT USAGE ON *.* TO `role5`
304 GRANT USAGE ON *.* TO `role6`
305 GRANT USAGE ON *.* TO `role7`
306 GRANT USAGE ON *.* TO `role9`
307 GRANT `role10` TO `foo`@`localhost`
308 GRANT `role1` TO `role2`
309 GRANT `role2` TO `role4`
310 GRANT `role2` TO `role5`
311 GRANT `role3` TO `role5`
312 GRANT `role4` TO `role6`
313 GRANT `role5` TO `role6`
314 GRANT `role5` TO `role7`
315 GRANT `role6` TO `role9`
316 GRANT `role7` TO `role9`
317 GRANT `role9` TO `role10`
318 connection default;
319 revoke select(User) on mysql.roles_mapping from role1;
320 show status like 'debug%';
321 Variable_name Value
322 Debug_role_merges_global 29
323 Debug_role_merges_db 17
324 Debug_role_merges_table 41
325 Debug_role_merges_column 24
326 Debug_role_merges_routine 0
327 connection foo;
328 select count(concat(User,Host)) from mysql.roles_mapping;
329 ERROR 42000: SELECT command denied to user 'foo'@'localhost' for column 'User' in table 'roles_mapping'
330 select count(concat(Host)) from mysql.roles_mapping;
331 count(concat(Host))
332 22
333 connection default;
334 revoke select(Host) on mysql.roles_mapping from role3;
335 show status like 'debug%';
336 Variable_name Value
337 Debug_role_merges_global 29
338 Debug_role_merges_db 17
339 Debug_role_merges_table 47
340 Debug_role_merges_column 30
341 Debug_role_merges_routine 0
342 connection foo;
343 select count(concat(Host)) from mysql.roles_mapping;
344 ERROR 42000: SELECT command denied to user 'foo'@'localhost' for table `mysql`.`roles_mapping`
345 set role none;
346 connection default;
347 create procedure pr1() select "pr1";
348 create function fn1() returns char(10) return "fn1";
349 grant execute on procedure test.pr1 to role1;
350 show status like 'debug%';
351 Variable_name Value
352 Debug_role_merges_global 29
353 Debug_role_merges_db 17
354 Debug_role_merges_table 47
355 Debug_role_merges_column 30
356 Debug_role_merges_routine 9
357 connection foo;
358 call pr1();
359 ERROR 42000: execute command denied to user 'foo'@'localhost' for routine 'test.pr1'
360 set role role10;
361 call pr1();
362 pr1
363 pr1
364 select fn1();
365 ERROR 42000: execute command denied to user 'foo'@'localhost' for routine 'test.fn1'
366 connection default;
367 grant execute on function test.fn1 to role5;
368 show status like 'debug%';
369 Variable_name Value
370 Debug_role_merges_global 29
371 Debug_role_merges_db 17
372 Debug_role_merges_table 47
373 Debug_role_merges_column 30
374 Debug_role_merges_routine 15
375 connection foo;
376 select fn1();
377 fn1()
378 fn1
379 connection default;
380 revoke execute on procedure test.pr1 from role1;
381 show status like 'debug%';
382 Variable_name Value
383 Debug_role_merges_global 29
384 Debug_role_merges_db 17
385 Debug_role_merges_table 47
386 Debug_role_merges_column 30
387 Debug_role_merges_routine 23
388 connection foo;
389 call pr1();
390 ERROR 42000: execute command denied to user 'foo'@'localhost' for routine 'test.pr1'
391 select fn1();
392 fn1()
393 fn1
394 connection default;
395 revoke execute on function test.fn1 from role5;
396 show status like 'debug%';
397 Variable_name Value
398 Debug_role_merges_global 29
399 Debug_role_merges_db 17
400 Debug_role_merges_table 47
401 Debug_role_merges_column 30
402 Debug_role_merges_routine 28
403 connection foo;
404 select fn1();
405 ERROR 42000: execute command denied to user 'foo'@'localhost' for routine 'test.fn1'
406 set role none;
407 connection default;
408 drop procedure pr1;
409 drop function fn1;
410 grant select on mysql.roles_mapping to role3;
411 show status like 'debug%';
412 Variable_name Value
413 Debug_role_merges_global 29
414 Debug_role_merges_db 17
415 Debug_role_merges_table 54
416 Debug_role_merges_column 30
417 Debug_role_merges_routine 28
418 grant select on mysql.roles_mapping to role1;
419 show status like 'debug%';
420 Variable_name Value
421 Debug_role_merges_global 29
422 Debug_role_merges_db 17
423 Debug_role_merges_table 58
424 Debug_role_merges_column 30
425 Debug_role_merges_routine 28
426 revoke select on mysql.roles_mapping from role3;
427 show status like 'debug%';
428 Variable_name Value
429 Debug_role_merges_global 29
430 Debug_role_merges_db 17
431 Debug_role_merges_table 59
432 Debug_role_merges_column 30
433 Debug_role_merges_routine 28
434 revoke select on mysql.roles_mapping from role1;
435 show status like 'debug%';
436 Variable_name Value
437 Debug_role_merges_global 29
438 Debug_role_merges_db 17
439 Debug_role_merges_table 67
440 Debug_role_merges_column 30
441 Debug_role_merges_routine 28
442 grant select on mysql.* to role1;
443 show status like 'debug%';
444 Variable_name Value
445 Debug_role_merges_global 29
446 Debug_role_merges_db 26
447 Debug_role_merges_table 67
448 Debug_role_merges_column 30
449 Debug_role_merges_routine 28
450 grant select on test.* to role1;
451 show status like 'debug%';
452 Variable_name Value
453 Debug_role_merges_global 29
454 Debug_role_merges_db 35
455 Debug_role_merges_table 67
456 Debug_role_merges_column 30
457 Debug_role_merges_routine 28
458 revoke select on mysql.* from role1;
459 show status like 'debug%';
460 Variable_name Value
461 Debug_role_merges_global 29
462 Debug_role_merges_db 43
463 Debug_role_merges_table 67
464 Debug_role_merges_column 30
465 Debug_role_merges_routine 28
466 revoke select on test.* from role1;
467 show status like 'debug%';
468 Variable_name Value
469 Debug_role_merges_global 29
470 Debug_role_merges_db 51
471 Debug_role_merges_table 67
472 Debug_role_merges_column 30
473 Debug_role_merges_routine 28
474 connection default;
475 drop user foo@localhost;
476 drop role role1;
477 drop role role2;
478 drop role role3;
479 drop role role4;
480 drop role role5;
481 drop role role6;
482 drop role role7;
483 drop role role8;
484 drop role role9;
485 drop role role10;
486 set global debug_dbug=@old_dbug;