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