Re: Reset permissions on table - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Reset permissions on table
Date
Msg-id 511E54C1.1080303@gmail.com
Whole thread Raw
In response to Re: Reset permissions on table  (etienne.champetier@free.fr)
List pgsql-general
On 02/15/2013 05:02 AM, etienne.champetier@free.fr wrote:
>

>
> If i do a GRANT and a REVOKE, i loose access to the table.
> \dp <table-name> return the same thing but before GRANT it's NULL and after REVOKE it's not.
>
> It matter when you want to change owner and you forgot this table where there is explicit right.

If it is a matter of finding who the table owner is then do:

\dt table_name


>
>>
>> Yours,
>> Laurenz Albe
>>
> Thanks for your quick answer
>
>


--
Adrian Klaver
adrian.klaver@gmail.com

pgsql-general by date:

Previous
From: Jack Christensen
Date:
Subject: Re: Avoiding duplication of code via views -- slower? How do people typically do this?
Next
From: Adrian Klaver
Date:
Subject: Re: pg_upgrade