This SQL script for Postgres will grant a user a full read-only access on all tables in all schemas and will also grant access to the tables created in future.
This is how you run it:
cd /home/postgres psql -d databasename -a -f multigrant.sql
-
Notifications
You must be signed in to change notification settings - Fork 0
devopsinthecloud/sql_multigrant
Folders and files
| Name | Name | Last commit message | Last commit date | |
|---|---|---|---|---|
Repository files navigation
About
SQL grant for Postgres
Resources
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published