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; |