Difference between revisions of "Postgres permissions"
Jump to navigation
Jump to search
(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...") |
(No difference)
|
Latest revision as of 01:08, 13 February 2023
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