Re: phantom rights

From: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "'Thomas Poty *EXTERN*'" <thomas(dot)poty(at)gmail(dot)com>, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: phantom rights
Date: 2017-08-02 06:43:10
Message-ID: A737B7A37273E048B164557ADEF4A58B60D76075@ntex2010i.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message amandeep singh 2017-08-02 12:36:05 Terminate connections using non-superuser
Previous Message Albe Laurenz 2017-08-02 06:39:52 Re: oracle_fdw issues