1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
|
###############################################################################
# WL#12098: MySQL system users #
# #
# This test file covers the scenarios around adding/removing the #
# restriction_list in mysql.user.user_attributes column. #
# #
# The restriction_list is a key:value pair. Database name serves as key, #
# and an array of static privileges which are prohibited on that database #
# serves as value. #
# #
# Refer the test file - partial_revokes_usage.test for the usage of #
# partial revokes once they are created #
# #
###############################################################################
--source include/set_privilege_checks_user_as_system_user.inc
--let $rpl_privilege_checks_user_grant_option = 1
--source include/master-slave.inc
SELECT @@global.partial_revokes;
--disable_query_log
CALL mtr.add_suppression("one or more privileges granted through");
CALL mtr.add_suppression("these are not valid database privileges");
CALL mtr.add_suppression("corresponding global privilege(s) are not granted");
CALL mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");
--enable_query_log
--let $TEST_MODE=RPL
--source ../../auth_sec/include/partial_revokes_add_remove.inc
--source include/rpl_end.inc
|
