Debian Codegraph @

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

raw
1 ###############################################################################
2 # WL#12920: Extend GRANT/REVOKE syntax to cover partial revokes information #
3 # #
4 # This file covers DDL tests convering GRANT syntax's extension to specify #
5 # user context through AS clause. #
6 # #
7 ###############################################################################
8
9 --source include/have_log_bin.inc
10
11 # Save the initial number of concurrent sessions
12 --source include/count_sessions.inc
13
14 # Set partial revokes to ON
15 SET @start_partial_revokes = @@global.partial_revokes;
16 SET @@global.partial_revokes=ON;
17
18 --disable_query_log
19 CALL mtr.add_suppression("one or more privileges granted through");
20 CALL mtr.add_suppression("these are not valid database privileges");
21 CALL mtr.add_suppression("corresponding global privilege(s) are not granted");
22 --enable_query_log
23
24 SET @@global.partial_revokes = ON;
25 SELECT @@global.partial_revokes;
26
27 --let $TEST_MODE = NORMAL
28 --source ../../auth_sec/include/grant_as_ddl.inc
29
30 # Toggle partial_revokes to its original value
31 SET @@global.partial_revokes = @start_partial_revokes;
32
33 # Wait till all disconnects are completed
34 --source include/wait_until_count_sessions.inc