summaryrefslogtreecommitdiff
path: root/mysql-test/main/plugin_auth.result
diff options
context:
space:
mode:
authorOleksandr Byelkin <sanja@mariadb.com>2019-11-06 12:35:19 +0100
committerOleksandr Byelkin <sanja@mariadb.com>2020-02-05 17:22:26 +0100
commitfafb35ee517f309d9e507f6e3908caca5d8cd257 (patch)
tree2b077c5fb367d221dd03b30365e66e9a8aa3b28f /mysql-test/main/plugin_auth.result
parentb3ded21922fc684c3c1aeb4ad57161bc2fec5859 (diff)
downloadmariadb-git-fafb35ee517f309d9e507f6e3908caca5d8cd257.tar.gz
MDEV-20076: SHOW GRANTS does not quote role names properlybb-10.3-MDEV-20076
Quotes added to output.
Diffstat (limited to 'mysql-test/main/plugin_auth.result')
-rw-r--r--mysql-test/main/plugin_auth.result6
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/main/plugin_auth.result b/mysql-test/main/plugin_auth.result
index eeb65187fea..66495da65e7 100644
--- a/mysql-test/main/plugin_auth.result
+++ b/mysql-test/main/plugin_auth.result
@@ -185,18 +185,18 @@ in default connection
disconnect proxy_admin_con;
SHOW GRANTS FOR grant_plug;
Grants for grant_plug@%
-GRANT ALL PRIVILEGES ON *.* TO 'grant_plug'@'%' IDENTIFIED VIA test_plugin_server USING 'grant_plug_dest'
+GRANT ALL PRIVILEGES ON *.* TO `grant_plug`@`%` IDENTIFIED VIA test_plugin_server USING 'grant_plug_dest'
GRANT PROXY ON 'future_user'@'%' TO 'grant_plug'@'%'
REVOKE PROXY ON future_user FROM grant_plug;
SHOW GRANTS FOR grant_plug;
Grants for grant_plug@%
-GRANT ALL PRIVILEGES ON *.* TO 'grant_plug'@'%' IDENTIFIED VIA test_plugin_server USING 'grant_plug_dest'
+GRANT ALL PRIVILEGES ON *.* TO `grant_plug`@`%` IDENTIFIED VIA test_plugin_server USING 'grant_plug_dest'
## testing drop user
CREATE USER test_drop@localhost;
GRANT PROXY ON future_user TO test_drop@localhost;
SHOW GRANTS FOR test_drop@localhost;
Grants for test_drop@localhost
-GRANT USAGE ON *.* TO 'test_drop'@'localhost'
+GRANT USAGE ON *.* TO `test_drop`@`localhost`
GRANT PROXY ON 'future_user'@'%' TO 'test_drop'@'localhost'
DROP USER test_drop@localhost;
SELECT * FROM mysql.proxies_priv WHERE Host = 'test_drop' AND User = 'localhost';