| 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'; |