Debian Codegraph @

mysql-test/suite/auth_sec/t/mandatory_roles_bugs.test

raw
1 --echo #
2 --echo # Bug #28699403: SHOW GRANTS THROW ERROR FOR EXISTING SESSION WHEN
3 --echo # MANDATORY_ROLES CHANGED
4
5 # Save the initial number of concurrent sessions
6 --source include/count_sessions.inc
7
8 CREATE USER u1@localhost;
9 CREATE ROLE r1;
10 CREATE TABLE t1 (a INT);
11 GRANT ALL ON t1 TO r1;
12 SET GLOBAL mandatory_roles="r1";
13 SET GLOBAL activate_all_roles_on_login = 'ON';
14
15 connect(con1,localhost,u1,,test);
16 connection con1;
17 --echo # in connection con1
18 SHOW GRANTS;
19 SELECT a FROM t1;
20 connection default;
21 --echo # in connection default
22 SET GLOBAL mandatory_roles="";
23 connection con1;
24 --echo # in connection con1
25 --echo # test: Must not fail
26 SHOW GRANTS;
27 --error ER_TABLEACCESS_DENIED_ERROR
28 SELECT * FROM t1;
29
30 connection default;
31 --echo # in connection default
32
33 disconnect con1;
34 DROP USER u1@localhost;
35 DROP ROLE r1;
36 DROP TABLE t1;
37 SET GLOBAL mandatory_roles=DEFAULT;
38 SET GLOBAL activate_all_roles_on_login=DEFAULT;
39 # Wait till all disconnects are completed
40 --source include/wait_until_count_sessions.inc
41
42
43 --echo # End of 8.0 tests