Re: [ADMIN] phantom rights
| От | Thomas Poty |
|---|---|
| Тема | Re: [ADMIN] phantom rights |
| Дата | |
| Msg-id | CAN_ctniQVZMJzwbDsHqbS-Y=oVg1OypTk99Cw_SCeHM2ik8uLQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: [ADMIN] phantom rights (Scott Marlowe <scott.marlowe@gmail.com>) |
| Ответы |
Re: [ADMIN] phantom rights
|
| Список | pgsql-admin |
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@gmail.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
В списке pgsql-admin по дате отправления: