Postgres permissions

From UVOO Tech Wiki
Revision as of 01:08, 13 February 2023 by Busk (talk | contribs) (Created page with "``` 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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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