Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.11.0
-
None
Description
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.
Attachments
Issue Links
- is part of
-
MDEV-5215 Granted to PUBLIC
-
- Closed
-
Activity
| Assignee | Oleksandr Byelkin [ sanja ] |
| Fix Version/s | 10.11 [ 27614 ] |
| Assignee | Oleksandr Byelkin [ sanja ] | Vicențiu Ciorbaru [ cvicentiu ] |
| issue.field.resolutiondate | 2022-10-10 15:44:50.0 | 2022-10-10 15:44:50.513 |
| Fix Version/s | 10.11.1 [ 28454 ] | |
| Fix Version/s | 10.11 [ 27614 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |