Details
Description
I noticed that MDEV-20076 is fixed already.
However, this is still minor issue left for SET DEFAULT ROLE
MariaDB [(none)]> show grants for 'exploit'@'host'; |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| Grants for exploit@host | |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| GRANT `role-exploit` TO `exploit`@`host` |
|
| GRANT USAGE ON *.* TO `exploit`@`host` IDENTIFIED BY PASSWORD '*' WITH MAX_STATEMENT_TIME 15.000000 | |
| SET DEFAULT ROLE role-exploit FOR 'exploit'@'host' |
If copy-pasted as-is, the last line gets a syntax error.
Can you update it so when showing grants, all of them are properly quoted?
SHOW GRANTS does not quote role names properly for DEFAULT ROLE
Attachments
Issue Links
- relates to
-
MDEV-20076 SHOW GRANTS does not quote role names properly
- Closed
-
MDEV-22313 SHOW GRANTS does not prints a user's default role
- Closed