blob: 723916f9211982583c7d2da8ea8f83af04831cad (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
create role r1;
create user foo@'127.0.0.1';
grant r1 to foo@'127.0.0.1';
connect con1,127.0.0.1,foo,,;
show grants;
Grants for foo@127.0.0.1
GRANT `r1` TO `foo`@`127.0.0.1`
GRANT USAGE ON *.* TO `foo`@`127.0.0.1`
set role r1;
select * from information_schema.enabled_roles;
ROLE_NAME
r1
connection default;
drop user foo@'127.0.0.1';
drop role r1;
|
