[MDEV-21875] Postfix for MDEV-20076: quotes in GRANT PROXY haven't been changed Created: 2020-03-04  Updated: 2023-04-27

Status: Open
Project: MariaDB Server
Component/s: Authentication and Privilege System
Affects Version/s: 10.3, 10.4
Fix Version/s: 10.4

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Oleksandr Byelkin
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-20076 SHOW GRANTS does not quote role names... Closed

 Description   

MDEV-20076 introduced a massive change of quote marks in SHOW GRANTS output. However, if the goal was to convert them uniformly to backquotes, it didn't happen. GRANT PROXY still uses single quotes.

MariaDB [test]> create user foo@localhost;
Query OK, 0 rows affected (0.000 sec)
 
MariaDB [test]> grant proxy on 'x-x' to foo@localhost;
Query OK, 0 rows affected (0.000 sec)
 
MariaDB [test]> show grants for foo@localhost;
+-----------------------------------------------+
| Grants for foo@localhost                      |
+-----------------------------------------------+
| GRANT USAGE ON *.* TO `foo`@`localhost`       |
| GRANT PROXY ON 'x-x'@'%' TO 'foo'@'localhost' |
+-----------------------------------------------+
2 rows in set (0.000 sec)
 
MariaDB [test]> set sql_mode='ORACLE';
Query OK, 0 rows affected (0.000 sec)
 
MariaDB [test]> show grants for foo@localhost;
+-----------------------------------------------+
| Grants for foo@localhost                      |
+-----------------------------------------------+
| GRANT USAGE ON *.* TO "foo"@"localhost"       |
| GRANT PROXY ON 'x-x'@'%' TO 'foo'@'localhost' |
+-----------------------------------------------+
2 rows in set (0.000 sec)


Generated at Thu Feb 08 09:10:30 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.