Debian Codegraph @

mysql-test/suite/binlog_nogtid/r/binlog_replication_applier_priv_checks.result

raw
1 CREATE USER 'u1'@'localhost' IDENTIFIED BY 'pass';
2 GRANT CREATE, SELECT ON *.* TO 'u1'@'localhost';
3 CREATE DATABASE rpl_priv;
4 USE rpl_priv;
5 CREATE TABLE t1 (a INT);
6 CALL mtr.add_suppression("INSERT command denied to user 'u1'@'localhost' for table 't1'");
7 #
8 # TC1. Apply a `Format_description_event` without any privileges
9 # --------------------------------------------------------------
10 #
11 BINLOG '
12 jbMGXQ8BAAAAeAAAAHwAAAAAAAQAOC4wLjE4LXRyLWRlYnVnAAAAAAAAAAAAAAAAAAAAAAAAAAAA
13 AAAAAAAAAAAAAAAAAACNswZdEwANAAgAAAAABAAEAAAAYAAEGggAAAAICAgCAAAACgoKKioAEjQA
14 CgGQNwbk';
15 ERROR 42000: Access denied; you need (at least one of) the SUPER, BINLOG_ADMIN or REPLICATION_APPLIER privilege(s) for this operation
16 GRANT REPLICATION_APPLIER ON *.* TO 'u1'@'localhost';
17 #
18 # TC2. Apply a `Write_row_event` without any privileges needed by the
19 # event
20 # -------------------------------------------------------------------
21 #
22 BINLOG '
23 jbMGXQ8BAAAAeAAAAHwAAAAAAAQAOC4wLjE4LXRyLWRlYnVnAAAAAAAAAAAAAAAAAAAAAAAAAAAA
24 AAAAAAAAAAAAAAAAAACNswZdEwANAAgAAAAABAAEAAAAYAAEGggAAAAICAgCAAAACgoKKioAEjQA
25 CgGQNwbk';
26 BINLOG '
27 g2YSXRMBAAAANAAAAG0BAAAAAJoAAAAAAAEACHJwbF9wcml2AAJ0MQABAwABAQEAdXCMmg==
28 g2YSXR4BAAAAMgAAAJ8BAAAAAJoAAAAAAAEAAgAB/wAKAAAAAAsAAAAADAAAAGmCVP4=
29 ';
30 ERROR HY000: Unknown error
31 GRANT INSERT ON *.* TO 'u1'@'localhost';
32 #
33 # TC3. Apply a `Write_row_event` with `INSERT` privilege
34 # ------------------------------------------------------
35 #
36 BINLOG '
37 jbMGXQ8BAAAAeAAAAHwAAAAAAAQAOC4wLjE4LXRyLWRlYnVnAAAAAAAAAAAAAAAAAAAAAAAAAAAA
38 AAAAAAAAAAAAAAAAAACNswZdEwANAAgAAAAABAAEAAAAYAAEGggAAAAICAgCAAAACgoKKioAEjQA
39 CgGQNwbk';
40 BINLOG '
41 g2YSXRMBAAAANAAAAG0BAAAAAJoAAAAAAAEACHJwbF9wcml2AAJ0MQABAwABAQEAdXCMmg==
42 g2YSXR4BAAAAMgAAAJ8BAAAAAJoAAAAAAAEAAgAB/wAKAAAAAAsAAAAADAAAAGmCVP4=
43 ';
44 include/assert.inc [INSERT succeeded]
45 DELETE FROM t1;
46 REVOKE INSERT, REPLICATION_APPLIER ON *.* FROM 'u1'@'localhost';
47 GRANT BINLOG_ADMIN ON *.* TO 'u1'@'localhost';
48 #
49 # TC4. Apply a `Write_row_event` with `BINLOG_ADMIN` privilege
50 # ------------------------------------------------------------
51 #
52 BINLOG '
53 jbMGXQ8BAAAAeAAAAHwAAAAAAAQAOC4wLjE4LXRyLWRlYnVnAAAAAAAAAAAAAAAAAAAAAAAAAAAA
54 AAAAAAAAAAAAAAAAAACNswZdEwANAAgAAAAABAAEAAAAYAAEGggAAAAICAgCAAAACgoKKioAEjQA
55 CgGQNwbk';
56 BINLOG '
57 g2YSXRMBAAAANAAAAG0BAAAAAJoAAAAAAAEACHJwbF9wcml2AAJ0MQABAwABAQEAdXCMmg==
58 g2YSXR4BAAAAMgAAAJ8BAAAAAJoAAAAAAAEAAgAB/wAKAAAAAAsAAAAADAAAAGmCVP4=
59 ';
60 include/assert.inc [INSERT succeeded]
61 DELETE FROM t1;
62 REVOKE BINLOG_ADMIN ON *.* FROM 'u1'@'localhost';
63 GRANT SUPER ON *.* TO 'u1'@'localhost';
64 Warnings:
65 Warning 1287 The SUPER privilege identifier is deprecated
66 #
67 # TC5. Apply a `Write_row_event` with `SUPER` privilege
68 # -----------------------------------------------------
69 #
70 BINLOG '
71 jbMGXQ8BAAAAeAAAAHwAAAAAAAQAOC4wLjE4LXRyLWRlYnVnAAAAAAAAAAAAAAAAAAAAAAAAAAAA
72 AAAAAAAAAAAAAAAAAACNswZdEwANAAgAAAAABAAEAAAAYAAEGggAAAAICAgCAAAACgoKKioAEjQA
73 CgGQNwbk';
74 BINLOG '
75 g2YSXRMBAAAANAAAAG0BAAAAAJoAAAAAAAEACHJwbF9wcml2AAJ0MQABAwABAQEAdXCMmg==
76 g2YSXR4BAAAAMgAAAJ8BAAAAAJoAAAAAAAEAAgAB/wAKAAAAAAsAAAAADAAAAGmCVP4=
77 ';
78 include/assert.inc [INSERT succeeded]
79 DROP DATABASE rpl_priv;
80 DROP USER 'u1'@'localhost';