NOTICE: table "rorole_minimal_test_table" does not exist, skipping DROP TABLE NOTICE: role "rorole_minimal_test_user" does not exist, skipping DROP ROLE NOTICE: role "no_rorole_minimal_test_user" does not exist, skipping DROP ROLE CREATE TABLE INSERT 0 2 CREATE ROLE CREATE ROLE GRANT ROLE GRANT WARNING: role "no_rorole_minimal_test_user" is not a member of role "pg_read_all_data" REVOKE ROLE SET session_user | current_user --------------------------+-------------------------- rorole_minimal_test_user | rorole_minimal_test_user (1 row) id ---- 1 2 (2 rows) ERROR: permission denied for table rorole_minimal_test_table SET session_user | current_user -----------------------------+----------------------------- no_rorole_minimal_test_user | no_rorole_minimal_test_user (1 row) ERROR: permission denied for table rorole_minimal_test_table ERROR: permission denied for table rorole_minimal_test_table