Debian Codegraph @

mysql-test/suite/roles/grant-5771.result

raw
1 create database mysqltest1;
2 create database mysqltest2;
3 create user foo@localhost;
4 create role r1, r2;
5 grant all on mysqltest1.* to r1;
6 grant all on mysqltest2.* to r2;
7 grant r1 to r2;
8 grant r2 to foo@localhost;
9 connect foo,localhost,foo,,;
10 select current_user;
11 current_user
12 foo@localhost
13 show tables in mysqltest1;
14 ERROR 42000: Access denied for user 'foo'@'localhost' to database 'mysqltest1'
15 show tables in mysqltest2;
16 ERROR 42000: Access denied for user 'foo'@'localhost' to database 'mysqltest2'
17 set role r2;
18 show tables in mysqltest1;
19 Tables_in_mysqltest1
20 show tables in mysqltest2;
21 Tables_in_mysqltest2
22 show grants;
23 Grants for foo@localhost
24 GRANT `r2` TO `foo`@`localhost`
25 GRANT USAGE ON *.* TO `foo`@`localhost`
26 GRANT `r1` TO `r2`
27 GRANT USAGE ON *.* TO `r2`
28 GRANT ALL PRIVILEGES ON `mysqltest2`.* TO `r2`
29 GRANT USAGE ON *.* TO `r1`
30 GRANT ALL PRIVILEGES ON `mysqltest1`.* TO `r1`
31 connection default;
32 drop user foo@localhost;
33 drop role r1;
34 drop role r2;
35 drop database mysqltest1;
36 drop database mysqltest2;