Busk: 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..."

2023-02-13T01:08:41Z

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..."

New page

```
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
```

Postgres permissions - Revision history

Busk: 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..."