Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Not a Bug
-
Affects Version/s: 10.2, 10.3, 10.4, 10.5, 10.6, 10.7, 10.8, 10.9, 10.10
-
Fix Version/s: N/A
-
Component/s: Authentication and Privilege System
-
Labels:None
Description
to see a database, for example, in SHOW DATABASES a user must have at least some privilege on that database. GRANT OPTION is enough:
GRANT USAGE ON *.* TO user@host WITH GRANT OPTION; |
allows to see all databases.
As GRANT OPTION is not a real privilege, perhaps it shouldn't allow to see databases?
MySQL Bug#25203933, fixed in 5.7.40 and in 8.0.17
Attachments
Issue Links
- links to