Postgres
| /* create user with password */ | |
| CREATE USER xxx WITH ENCRYPTED PASSWORD 'xxxxxxx'; | |
| /* set permissions */ | |
| GRANT CONNECT ON DATABASE mydb TO xxx; | |
| GRANT USAGE ON SCHEMA public TO xxx; | |
| GRANT SELECT ON ALL TABLES IN SCHEMA public TO xxx; | |
| ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO xxx; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment