Debian Codegraph @

mysql-test/suite/binlog/t/binlog_grant.test

raw
1
2 # Test grants for various objects (especially variables) related to
3 # the binary log
4
5 source include/have_log_bin.inc;
6
7 connection default;
8 --disable_warnings
9 reset master;
10 --enable_warnings
11
12 set @saved_binlog_format = @@global.binlog_format;
13 create user mysqltest_1@localhost;
14 show grants for mysqltest_1@localhost;
15
16 connect (plain,localhost,mysqltest_1,,test);
17 connect (root,localhost,root,,test);
18
19 # Testing setting session SQL_LOG_BIN variable both as
20 # root and as plain user.
21
22 --echo **** Variable SQL_LOG_BIN ****
23
24 connection root;
25 --echo [root]
26 set session sql_log_bin = 1;
27
28 connection plain;
29 --echo [plain]
30 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
31 set session sql_log_bin = 1;
32
33
34 # Testing setting both session and global BINLOG_FORMAT variable both
35 # as root and as plain user.
36
37 --echo **** Variable BINLOG_FORMAT ****
38
39 connection root;
40 --echo [root]
41 set global binlog_format = 'row';
42 set session binlog_format = 'row';
43
44 connection plain;
45 --echo [plain]
46 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
47 set global binlog_format = 'row';
48 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
49 set session binlog_format = 'row';
50
51 --echo **** Clean up ****
52 disconnect plain;
53 disconnect root;
54
55 connection default;
56 set global binlog_format = @saved_binlog_format;
57 drop user mysqltest_1@localhost;
58
59
60 # Testing if REPLICATION CLIENT privilege is enough to execute
61 # SHOW MASTER LOGS and SHOW BINARY.
62 CREATE USER 'mysqltest_1'@'localhost';
63 GRANT REPLICATION CLIENT ON *.* TO 'mysqltest_1'@'localhost';
64 --connect(rpl,localhost,mysqltest_1,,)
65
66 --connection rpl
67 # We are only interested if the following commands succeed and not on
68 # their output.
69 --disable_result_log
70 SHOW MASTER LOGS;
71 SHOW BINARY LOGS;
72 --enable_result_log
73
74 # clean up
75 --disconnect rpl
76 connection default;
77 DROP USER 'mysqltest_1'@'localhost';
78
79
80 --echo #
81 --echo # Bug #31869146: 'GRANT SELECT, GRANT OPTION ON *.* ' WOULD NOT WRITE
82 --echo # THE PRIVILEGES TO BINLOG
83 --echo #
84
85 let $binlog_start= query_get_value(SHOW MASTER STATUS, Position, 1);
86 CREATE USER b31869146@localhost;
87 CREATE DATABASE b31869146_db;
88 CREATE TABLE b31869146_db.t1 (a INT);
89 GRANT SELECT,GRANT OPTION ON *.* TO b31869146@localhost AS 'root'@'localhost' WITH ROLE NONE;
90 GRANT SELECT,GRANT OPTION ON b31869146_db.* TO b31869146@localhost;
91 GRANT SELECT,GRANT OPTION ON b31869146_db.t1 TO b31869146@localhost;
92 GRANT SELECT (a),GRANT OPTION ON b31869146_db.t1 TO b31869146@localhost;
93 GRANT SELECT ON *.* TO b31869146@localhost WITH GRANT OPTION AS 'root'@'localhost' WITH ROLE NONE;
94 GRANT SELECT ON b31869146_db.* TO b31869146@localhost WITH GRANT OPTION;
95 GRANT SELECT ON b31869146_db.t1 TO b31869146@localhost WITH GRANT OPTION;
96 GRANT SELECT (a) ON b31869146_db.t1 TO b31869146@localhost WITH GRANT OPTION;
97
98 --echo # Success must contain SELECT for all of the GRANTS
99 --echo # Show binlog events
100 source include/show_binlog_events.inc;
101
102 --echo # cleanup
103 DROP USER b31869146@localhost;
104 DROP DATABASE b31869146_db;
105
106 --echo # End of 8.0 tests