Debian Codegraph @

mysql-test/suite/roles/set_role-5232.result

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