Actually, I already did a test similar.
I checked the columns aclitems and relname in pg_class.
I wanted to be sure there is no phantom rights problem.
Thanks a lot,
Regards,
Thomas
Le 1 août 2017 5:40 PM, "Scott Marlowe" <scott.marlowe@xxxxxxxxx> a écrit :
Further:
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
