Debian Codegraph @

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

raw
1 ###############################################################################
2 # WL#12098: MySQL system users #
3 # #
4 # This test file covers the usage of partial revokes. #
5 # In other words how does the partial_revokes restricts DML/DDL access on #
6 # databases for which they are created. #
7 # #
8 # Refer the test file - partial_revokes_add_remove.test to understand #
9 # the various scenarios of adding/removing partial revokes #
10 # #
11 ###############################################################################
12
13 # Save the initial number of concurrent sessions
14 --source include/count_sessions.inc
15
16 --disable_query_log
17 let $saved_partial_revokes = `SELECT @@global.partial_revokes`;
18 --disable_warnings
19 SET GLOBAL partial_revokes= ON;
20 --enable_warnings
21 --enable_query_log
22 --let $TEST_MODE = NORMAL
23 --source ../include/partial_revokes_dml.inc
24
25 --disable_query_log
26 --disable_warnings
27 eval SET GLOBAL partial_revokes = $saved_partial_revokes;
28 --enable_warnings
29 --enable_query_log
30 # Wait till we reached the initial number of concurrent sessions
31 --source include/wait_until_count_sessions.inc