MariaDB [(none)]> show grants;
|
+------------------------------------------------+
|
| Grants for developer@% |
|
+------------------------------------------------+
|
| GRANT USAGE ON *.* TO `developer`@`%` |
|
| GRANT ALL PRIVILEGES ON `dev_db`.* TO `PUBLIC` |
|
+------------------------------------------------+
|
2 rows in set (0.000 sec)
|
|
MariaDB [(none)]> show grants for public;
|
ERROR 1044 (42000): Access denied for user 'developer'@'%' to database 'mysql'
|
Any user can see public's grants by running their own SHOW GRANTS command. This means that SHOW GRANTS FOR PUBLIC should also be allowed.
Bug
Major
MDEV-5215 Granted to PUBLIC
