Re: default privileges - Mailing list pgsql-hackers

From Tom Lane
Subject Re: default privileges
Date
Msg-id 331.1270432757@sss.pgh.pa.us
Whole thread Raw
In response to Re: default privileges  (Jaime Casanova <jcasanov@systemguards.com.ec>)
Responses Re: default privileges  (Jaime Casanova <jcasanov@systemguards.com.ec>)
List pgsql-hackers
Jaime Casanova <jcasanov@systemguards.com.ec> writes:
> On Sat, Apr 3, 2010 at 5:27 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Not sure if this is good enough or we need to provide some more-obvious
>> way of dealing with it.

> it's strange that a REVOKE doesn't clean what a GRANT did, and DROP
> OWNED BY seems very dangerous (at least if i forgot to make REASSIGN
> OWNED first).

Agreed --- I fixed it so that granting or revoking back to the default
permissions set will remove the entry.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: dmetaphone woes
Next
From: Tom Lane
Date:
Subject: Re: dmetaphone woes