diff options
author | Oleksandr Byelkin <sanja@mariadb.com> | 2019-11-06 12:35:19 +0100 |
---|---|---|
committer | Oleksandr Byelkin <sanja@mariadb.com> | 2020-02-05 17:22:26 +0100 |
commit | fafb35ee517f309d9e507f6e3908caca5d8cd257 (patch) | |
tree | 2b077c5fb367d221dd03b30365e66e9a8aa3b28f /mysql-test/suite/galera/r/galera_roles.result | |
parent | b3ded21922fc684c3c1aeb4ad57161bc2fec5859 (diff) | |
download | mariadb-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/suite/galera/r/galera_roles.result')
-rw-r--r-- | mysql-test/suite/galera/r/galera_roles.result | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/mysql-test/suite/galera/r/galera_roles.result b/mysql-test/suite/galera/r/galera_roles.result index bef89acfc92..7d6c57e8131 100644 --- a/mysql-test/suite/galera/r/galera_roles.result +++ b/mysql-test/suite/galera/r/galera_roles.result @@ -26,8 +26,8 @@ connect foo_node_2,127.0.0.1,foo,,test,$port_2,; connection foo_node_1; SHOW GRANTS; Grants for foo@localhost -GRANT role1 TO 'foo'@'localhost' -GRANT USAGE ON *.* TO 'foo'@'localhost' +GRANT `role1` TO `foo`@`localhost` +GRANT USAGE ON *.* TO `foo`@`localhost` FLUSH TABLES; ERROR 42000: Access denied; you need (at least one of) the RELOAD privilege(s) for this operation SELECT * FROM mysql.roles_mapping; @@ -62,8 +62,8 @@ pr1 connection foo_node_2; SHOW GRANTS; Grants for foo@localhost -GRANT role1 TO 'foo'@'localhost' -GRANT USAGE ON *.* TO 'foo'@'localhost' +GRANT `role1` TO `foo`@`localhost` +GRANT USAGE ON *.* TO `foo`@`localhost` FLUSH TABLES; ERROR 42000: Access denied; you need (at least one of) the RELOAD privilege(s) for this operation SELECT * FROM mysql.roles_mapping; @@ -129,7 +129,7 @@ SELECT a FROM test1.t2; ERROR 42000: SELECT command denied to user 'foo'@'localhost' for table 't2' SHOW GRANTS; Grants for foo@localhost -GRANT USAGE ON *.* TO 'foo'@'localhost' +GRANT USAGE ON *.* TO `foo`@`localhost` SELECT * FROM INFORMATION_SCHEMA.ENABLED_ROLES; ROLE_NAME NULL @@ -151,7 +151,7 @@ SELECT a FROM test1.t2; ERROR 42000: SELECT command denied to user 'foo'@'localhost' for table 't2' SHOW GRANTS; Grants for foo@localhost -GRANT USAGE ON *.* TO 'foo'@'localhost' +GRANT USAGE ON *.* TO `foo`@`localhost` SELECT * FROM INFORMATION_SCHEMA.ENABLED_ROLES; ROLE_NAME NULL |