pg_rorole_v2_minimal_test.out
application/octet-stream
Filename: pg_rorole_v2_minimal_test.out
Type: application/octet-stream
Part: 0
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