Debian Codegraph @

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

raw
1 #
2 # MDEV-5232 SET ROLE checks privileges differently from check_access()
3 #
4 --source include/not_embedded.inc
5 create user ''@localhost;
6 create user c;
7 grant select on mysql.* to c;
8 create role r1;
9 grant r1 to c;
10 connect (c,localhost,c,,,,,);
11 select user(), current_user();
12 --error ER_TABLEACCESS_DENIED_ERROR
13 select user from mysql.user group by user;
14 --error ER_INVALID_ROLE
15 set role r1;
16 disconnect c;
17 connection default;
18 drop role r1;
19 drop user c;
20 drop user ''@localhost;