Debian Codegraph @

mysql-test/suite/sys_vars/t/binlog_direct_non_transactional_updates_grant.test

raw
1 source include/have_log_bin.inc;
2
3 SET @global= @@global.binlog_direct_non_transactional_updates;
4 SET @session= @@global.binlog_direct_non_transactional_updates;
5
6 --echo #
7 --echo #
8 --echo #
9
10 --echo # Test that "SET binlog_direct_non_transactional_updates" is not allowed without BINLOG ADMIN
11
12 CREATE USER user1@localhost;
13 GRANT ALL PRIVILEGES ON *.* TO user1@localhost;
14 REVOKE BINLOG ADMIN ON *.* FROM user1@localhost;
15 --connect(user1,localhost,user1,,)
16 --connection user1
17 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
18 SET binlog_direct_non_transactional_updates=0;
19 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
20 SET GLOBAL binlog_direct_non_transactional_updates=0;
21 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
22 SET SESSION binlog_direct_non_transactional_updates=0;
23 --disconnect user1
24 --connection default
25 DROP USER user1@localhost;
26
27 --echo # Test that "SET binlog_direct_non_transactional_updates" is allowed with BINLOG ADMIN
28
29 CREATE USER user1@localhost;
30 GRANT BINLOG ADMIN ON *.* TO user1@localhost;
31 --connect(user1,localhost,user1,,)
32 --connection user1
33 SET binlog_direct_non_transactional_updates=0;
34 SET GLOBAL binlog_direct_non_transactional_updates=0;
35 SET SESSION binlog_direct_non_transactional_updates=0;
36 --disconnect user1
37 --connection default
38 DROP USER user1@localhost;
39
40 SET GLOBAL binlog_direct_non_transactional_updates=@global;
41 SET SESSION binlog_direct_non_transactional_updates=@session;