Postgres permissions
Jump to navigation
Jump to search
CREATE ROLE viewer; CREATE ROLE editor; CREATE ROLE admin; GRANT SELECT ON ALL TABLES IN SCHEMA public TO viewer; ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO viewer; ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT,INSERT,UPDATE ON TABLES TO editor; GRANT some_other_privs_to_admin_group