Debian Codegraph @

mysql-test/suite/sys_vars/r/binlog_direct_non_transactional_updates_grant.result

raw
1 SET @global= @@global.binlog_direct_non_transactional_updates;
2 SET @session= @@global.binlog_direct_non_transactional_updates;
3 #
4 #
5 #
6 # Test that "SET binlog_direct_non_transactional_updates" is not allowed without BINLOG ADMIN
7 CREATE USER user1@localhost;
8 GRANT ALL PRIVILEGES ON *.* TO user1@localhost;
9 REVOKE BINLOG ADMIN ON *.* FROM user1@localhost;
10 connect user1,localhost,user1,,;
11 connection user1;
12 SET binlog_direct_non_transactional_updates=0;
13 ERROR 42000: Access denied; you need (at least one of) the BINLOG ADMIN privilege(s) for this operation
14 SET GLOBAL binlog_direct_non_transactional_updates=0;
15 ERROR 42000: Access denied; you need (at least one of) the BINLOG ADMIN privilege(s) for this operation
16 SET SESSION binlog_direct_non_transactional_updates=0;
17 ERROR 42000: Access denied; you need (at least one of) the BINLOG ADMIN privilege(s) for this operation
18 disconnect user1;
19 connection default;
20 DROP USER user1@localhost;
21 # Test that "SET binlog_direct_non_transactional_updates" is allowed with BINLOG ADMIN
22 CREATE USER user1@localhost;
23 GRANT BINLOG ADMIN ON *.* TO user1@localhost;
24 connect user1,localhost,user1,,;
25 connection user1;
26 SET binlog_direct_non_transactional_updates=0;
27 SET GLOBAL binlog_direct_non_transactional_updates=0;
28 SET SESSION binlog_direct_non_transactional_updates=0;
29 disconnect user1;
30 connection default;
31 DROP USER user1@localhost;
32 SET GLOBAL binlog_direct_non_transactional_updates=@global;
33 SET SESSION binlog_direct_non_transactional_updates=@session;