Debian Codegraph @

mysql-test/suite/roles/create_and_grant_role.result

raw
1 create role r1;
2 grant r1 to root@localhost;
3 create user u1;
4 set role r1;
5 grant r1 to u1;
6 select * from mysql.roles_mapping;
7 Host User Role Admin_option
8 % u1 r1 N
9 localhost root r1 Y
10 drop user u1;
11 select * from mysql.roles_mapping;
12 Host User Role Admin_option
13 localhost root r1 Y
14 show grants;
15 Grants for root@localhost
16 GRANT ALL PRIVILEGES ON *.* TO `root`@`localhost` WITH GRANT OPTION
17 GRANT PROXY ON ''@'%' TO 'root'@'localhost' WITH GRANT OPTION
18 GRANT USAGE ON *.* TO `r1`
19 GRANT `r1` TO `root`@`localhost` WITH ADMIN OPTION
20 drop role r1;
21 select * from mysql.roles_mapping;
22 Host User Role Admin_option
23 show grants;
24 Grants for root@localhost
25 GRANT ALL PRIVILEGES ON *.* TO `root`@`localhost` WITH GRANT OPTION
26 GRANT PROXY ON ''@'%' TO 'root'@'localhost' WITH GRANT OPTION