diff options
| author | Sujatha <sujatha.sivakumar@mariadb.com> | 2020-11-16 14:31:44 +0530 |
|---|---|---|
| committer | Sujatha <sujatha.sivakumar@mariadb.com> | 2020-11-16 14:31:44 +0530 |
| commit | 6da68049b5d28246c5773fc2caee7bef6c6fc68f (patch) | |
| tree | 01851367f02fe3bd29dcd4425bc86f5e81ea4599 /mysql-test/main/grant.test | |
| parent | 1edd224372d9399a43a21c5c387aff84512f55e5 (diff) | |
| download | mariadb-git-6da68049b5d28246c5773fc2caee7bef6c6fc68f.tar.gz | |
MDEV-23610: Slave user can't run "SHOW SLAVE STATUS" anymore after upgrade to 10.5, mysql_upgrade should take of that
Add a new privilege "SLAVE MONITOR" which will grant user the permission
to execute "SHOW SLAVE STATUS" and "SHOW RELAYLOG EVENTS" commands.
SHOW SLAVE STATUS requires either SLAVE MONITOR/SUPER
SHOW RELAYLOG EVENTS requires SLAVE MONITOR privilege.
Diffstat (limited to 'mysql-test/main/grant.test')
| -rw-r--r-- | mysql-test/main/grant.test | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/mysql-test/main/grant.test b/mysql-test/main/grant.test index 38baf673825..a81e77567b5 100644 --- a/mysql-test/main/grant.test +++ b/mysql-test/main/grant.test @@ -1833,6 +1833,7 @@ GRANT REPLICATION SLAVE ON *.* TO mysqltest_u1@localhost; GRANT SHOW DATABASES ON *.* TO mysqltest_u1@localhost; GRANT SHUTDOWN ON *.* TO mysqltest_u1@localhost; GRANT USAGE ON *.* TO mysqltest_u1@localhost; +GRANT SLAVE MONITOR ON *.* TO mysqltest_u1@localhost; --echo SHOW GRANTS FOR mysqltest_u1@localhost; |