Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.3(EOL), 10.4(EOL)
-
None
Description
SHOW GRANTS output doesn't show the GRANT OPTION if ROLE is created with it.
MariaDB [(none)]> CREATE ROLE DB_Admin;
|
Query OK, 0 rows affected (0.000 sec)
|
|
MariaDB [(none)]> GRANT SELECT, UPDATE, DELETE, ALTER ON *.* TO 'DB_Admin' WITH GRANT OPTION;
|
Query OK, 0 rows affected (0.001 sec)
|
|
MariaDB [(none)]> SHOW GRANTS for 'DB_Admin';
|
+---------------------------------------------------------------+
|
| Grants for MariaDB_admin |
|
+---------------------------------------------------------------+
|
| GRANT SELECT, UPDATE, DELETE, ALTER ON *.* TO `MariaDB_admin` |
|
+---------------------------------------------------------------+
|
1 row in set (0.000 sec)
|
Attachments
Issue Links
- duplicates
-
MDEV-24289 show grants missing with grant
- Closed