pg_rorole_v2_minimal_test.out

application/octet-stream

Filename: pg_rorole_v2_minimal_test.out
Type: application/octet-stream
Part: 0
Message: Re: New default role- 'pg_read_all_data'
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