For complete understanding of the below-listed SQL privileges, see the PostgreSQL documentation.
| "Read only" role | "Read and write" role | "Admin" role |
Database | Run SELECT queries on all tables and views on the DB | Run SELECT, INSERT, UPDATE, DELETE queries on all tables and views on the DB | Run SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER queries on all tables and views on the DB.
Grant the permission to create and delete all objects under the DB.
Grant the permission to create and delete users and roles. Grant the permission to grant and revoke privileges to users and roles. |
Schema | Run SELECT queries on all tables and views on the schema | Run SELECT, INSERT, UPDATE, DELETE queries on all tables and views on the schema | Run SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER queries on all tables and views on the schema.
Also, grant the permission to CREATE object in the schema
|
Table | Run SELECT queries on table | Run SELECT, INSERT, UPDATE, DELETE queries on table | Run SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER queries on table |
View | Run SELECT queries on view | Run SELECT, INSERT, UPDATE, DELETE queries on view | Run SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER queries on view |