Created
May 20, 2024 04:42
-
-
Save rafirh/49da26bf7651f59af14ba77eef133f30 to your computer and use it in GitHub Desktop.
Grant Access to a Schema
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
GRANT USAGE ON SCHEMA "user" TO username; | |
GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA "user" TO username; | |
GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA "user" TO username; | |
GRANT USAGE ON ALL SEQUENCES IN SCHEMA "user" TO username; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment