[MDEV-21875] Postfix for MDEV-20076: quotes in GRANT PROXY haven't been changed - Jira

Details

Type: Bug
Status: Open (View Workflow)
Priority: Minor
Resolution: Unresolved
Affects Version/s: 10.3(EOL), 10.4(EOL)
Fix Version/s: 10.4(EOL)
Component/s: Authentication and Privilege System
Labels:
None

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)

Attachments

Issue Links

relates to

MDEV-20076 SHOW GRANTS does not quote role names properly

Closed

Activity

There are no comments yet on this issue.

People

Assignee:: Oleksandr Byelkin

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 2020-03-04 22:09

Updated:: 2023-04-27 13:55

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server