Details
-
Type:
Task
-
Status: In Progress (View Workflow)
-
Priority:
Critical
-
Resolution: Unresolved
-
Fix Version/s: 10.10
-
Component/s: Authentication and Privilege System
-
Labels:
Description
Implement the standard behavior for
GRANT xxx TO PUBLIC; |
REVOKE xxx FROM PUBLIC; |
Also, this statement is supposed to work:
SHOW GRANTS FOR PUBLIC; |
And these should not
CREATE ROLE PUBLIC; |
DROP ROLE PUBLIC; |
SET ROLE PUBLIC; |
GRANT PUBLIC TO xxx; |
REVOKE PUBLIC FROM xxx; |
Note that
SHOW GRANTS FOR xxx; |
should not list roles and privileges granted to PUBLIC (unless granted to xxx too), but
SHOW GRANTS;
|
should, arguably, list them.
Attachments
Issue Links
- blocks
-
MDEV-20947 Use GRANT ... TO PUBLIC for default test database privileges
-
- Open
-
- relates to
-
MDEV-4397 Roles
-
- Closed
-