Re: phantom rights

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(dot)marlowe(at)gmail(dot)com> 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
>