blob: 1afd649636eab8d2020e133a43afe464dfb7f0e3 (
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;
|
