Debian Codegraph @

mysql-test/suite/roles/ip-6401.result

raw
1 create role r1;
2 create user foo@'127.0.0.1';
3 grant r1 to foo@'127.0.0.1';
4 connect con1,127.0.0.1,foo,,;
5 show grants;
6 Grants for [email protected]
7 GRANT `r1` TO `foo`@`127.0.0.1`
8 GRANT USAGE ON *.* TO `foo`@`127.0.0.1`
9 set role r1;
10 select * from information_schema.enabled_roles;
11 ROLE_NAME
12 r1
13 connection default;
14 drop user foo@'127.0.0.1';
15 drop role r1;