blob: 6158c95e5c0ab9356f12a9c8145359b93a041614 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
create user ''@localhost;
create user c;
grant select on mysql.* to c;
create role r1;
grant r1 to c;
connect c,localhost,c,,,,,;
select user(), current_user();
user() current_user()
c@localhost @localhost
select user from mysql.user group by user;
ERROR 42000: SELECT command denied to user ''@'localhost' for table `mysql`.`user`
set role r1;
ERROR OP000: Invalid role specification `r1`
disconnect c;
connection default;
drop role r1;
drop user c;
drop user ''@localhost;
|
