I would like it, if I could use wildcards in GRANT and REVOKE.
For example
GRANT SELECT ON test* TO FREDT i.e. Fredt may select from all tables beginning with "test" or GRANT SELECT ON * TO FREDT Fredt may select from all tables.
This is not in the SQL standard. But the second suggestion, perhaps with a schema name, may be useful as a shortcut
Log in to post a comment.
This is not in the SQL standard. But the second suggestion, perhaps with a schema name, may be useful as a shortcut