Re: Reset permissions on table

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