Debian Codegraph @

mysql-test/suite/roles/create_and_grant_role.test

raw
1 source include/not_embedded.inc;
2
3 create role r1;
4 grant r1 to root@localhost;
5 create user u1;
6 set role r1;
7
8 grant r1 to u1;
9 --sorted_result
10 select * from mysql.roles_mapping;
11
12 drop user u1;
13 --sorted_result
14 select * from mysql.roles_mapping;
15 --sorted_result
16 show grants;
17 drop role r1;
18 --sorted_result
19 select * from mysql.roles_mapping;
20 --sorted_result
21 show grants;