[MDEV-5215] Granted to PUBLIC - Jira

XML

Word

Printable

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.

blocks

MDEV-20947 Use GRANT ... TO PUBLIC for default test database privileges

relates to

MDEV-4397 Roles