Re: [ADMIN] phantom rights - Mailing list pgsql-admin

From Albe Laurenz
Subject Re: [ADMIN] phantom rights
Date
Msg-id A737B7A37273E048B164557ADEF4A58B60D76075@ntex2010i.host.magwien.gv.at
Whole thread Raw
In response to Re: [ADMIN] phantom rights  (Thomas Poty <thomas.poty@gmail.com>)
List pgsql-admin
Thomas Poty wrote:
> I checked the columns aclitems and relname in pg_class.
> I wanted to be sure there is no phantom rights problem.

Right.

The problem does not exist if you store the permissions
on the object itself, like PostgreSQL does, so that dropping
the object also removes the permissions.

Yours,
Laurenz Albe

pgsql-admin by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: [ADMIN] oracle_fdw issues
Next
From: amandeep singh
Date:
Subject: [ADMIN] Terminate connections using non-superuser