Debian Codegraph @

mysql-test/suite/roles/flush_roles-17898.result

raw
1 use mysql;
2 insert db (db,user,select_priv) values ('foo','dwr_foo','Y'), ('bar','dwr_bar','Y');
3 insert roles_mapping (user,role) values ('dwr_qux_dev','dwr_foo'),('dwr_qux_dev','dwr_bar');
4 insert global_priv values ('','dwr_foo','{"is_role":true}'), ('','dwr_bar','{"is_role":true}'),
5 ('','dwr_qux_dev','{"access":16384,"is_role":true}');
6 flush privileges;
7 drop role dwr_foo;
8 drop role dwr_bar;
9 drop role dwr_qux_dev;
10 use test;
11 create table db_copy as select * from mysql.db;
12 delete from mysql.db;
13 flush privileges;
14 create user u1@localhost;
15 create role r1;
16 create role r2;
17 grant r1 to u1@localhost;
18 grant select on test.* to r2;
19 grant select on m_.* to r2;
20 grant r2 to r1;
21 show grants for u1@localhost;
22 Grants for u1@localhost
23 GRANT `r1` TO `u1`@`localhost`
24 GRANT USAGE ON *.* TO `u1`@`localhost`
25 show grants for r1;
26 Grants for r1
27 GRANT `r2` TO `r1`
28 GRANT USAGE ON *.* TO `r1`
29 GRANT USAGE ON *.* TO `r2`
30 GRANT SELECT ON `test`.* TO `r2`
31 GRANT SELECT ON `m_`.* TO `r2`
32 drop user u1@localhost;
33 drop role r1, r2;
34 insert mysql.db select * from db_copy;
35 flush privileges;
36 drop table db_copy;