Details
-
New Feature
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
Description
SHOW CREATE ROLE doesn't work.
See here:
MariaDB [(none)]> CREATE ROLE 'admin_role'; |
Query OK, 0 rows affected (0.002 sec) |
|
MariaDB [(none)]> CREATE ROLE 'user_role' WITH ADMIN 'admin_role'; |
Query OK, 0 rows affected (0.004 sec) |
|
MariaDB [(none)]> SHOW CREATE ROLE 'user_role'; |
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ROLE 'user_role'' at line 1 |
Since you can create a role with its own WITH ADMIN clause, this statement should be implemented, so that all role attributes can be easily printed.
Attachments
Issue Links
- relates to
-
MDEV-22312 Bad error message for SET DEFAULT ROLE when user account is not granted the role
- Closed
-
MDEV-22313 SHOW GRANTS does not prints a user's default role
- Closed
-
MDEV-23630 mysqldump to logically dump system tables
- Closed