| From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
|---|---|
| To: | etienne(dot)champetier(at)free(dot)fr |
| Cc: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Reset permissions on table |
| Date: | 2013-02-15 15:31:13 |
| Message-ID: | 511E54C1.1080303@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 02/15/2013 05:02 AM, etienne(dot)champetier(at)free(dot)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(dot)klaver(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2013-02-15 15:34:47 | Re: pg_upgrade |
| Previous Message | Jack Christensen | 2013-02-15 15:08:12 | Re: Avoiding duplication of code via views -- slower? How do people typically do this? |