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/versioning | |
| 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/versioning')
| -rw-r--r-- | mysql-test/suite/versioning/r/truncate_privilege.result | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/mysql-test/suite/versioning/r/truncate_privilege.result b/mysql-test/suite/versioning/r/truncate_privilege.result index 3242c4557c5..e2b48c494be 100644 --- a/mysql-test/suite/versioning/r/truncate_privilege.result +++ b/mysql-test/suite/versioning/r/truncate_privilege.result @@ -9,7 +9,7 @@ create table mysqltest.t (a int) with system versioning; connection user1; show grants; Grants for mysqltest_1@localhost -GRANT USAGE ON *.* TO 'mysqltest_1'@'localhost' +GRANT USAGE ON *.* TO `mysqltest_1`@`localhost` delete history from mysqltest.t before system_time now(); ERROR 42000: DELETE HISTORY command denied to user 'mysqltest_1'@'localhost' for table 't' connection root; @@ -18,16 +18,16 @@ grant delete history on mysqltest.t to mysqltest_1@localhost; connection user1; show grants; Grants for mysqltest_1@localhost -GRANT USAGE ON *.* TO 'mysqltest_1'@'localhost' -GRANT DELETE HISTORY ON `mysqltest`.* TO 'mysqltest_1'@'localhost' -GRANT DELETE HISTORY ON `mysqltest`.`t` TO 'mysqltest_1'@'localhost' +GRANT USAGE ON *.* TO `mysqltest_1`@`localhost` +GRANT DELETE HISTORY ON `mysqltest`.* TO `mysqltest_1`@`localhost` +GRANT DELETE HISTORY ON `mysqltest`.`t` TO `mysqltest_1`@`localhost` delete history from mysqltest.t before system_time now(); connection root; grant all on *.* to mysqltest_1@localhost; show grants for mysqltest_1@localhost; Grants for mysqltest_1@localhost -GRANT ALL PRIVILEGES ON *.* TO 'mysqltest_1'@'localhost' -GRANT DELETE HISTORY ON `mysqltest`.* TO 'mysqltest_1'@'localhost' -GRANT DELETE HISTORY ON `mysqltest`.`t` TO 'mysqltest_1'@'localhost' +GRANT ALL PRIVILEGES ON *.* TO `mysqltest_1`@`localhost` +GRANT DELETE HISTORY ON `mysqltest`.* TO `mysqltest_1`@`localhost` +GRANT DELETE HISTORY ON `mysqltest`.`t` TO `mysqltest_1`@`localhost` drop user mysqltest_1@localhost; drop database mysqltest; |