smarlowe=# \c smarlowe stan You are now connected to database "smarlowe" as user "stan". smarlowe=> \z test Access privileges Schema | Name | Type | Access privileges | Column privileges | Policies --------+------+-------+-------------------+-------------------+---------- public | test | table | | | (1 row)
smarlowe=> select * from test; ERROR: permission denied for relation test
