On 02/15/2013 05:02 AM, etienne.champet...@free.fr wrote:
If i do a GRANT and a REVOKE, i loose access to the table.
\dp 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 r
etienne champetier wrote:
>>> By default there is no permissions on table (\dp return 0 row)
>>> If I make a GRANT, doing a REVOKE will not get me in the 'default'
>>> state
>>>
>>> How to return in the default state, where permission are
>>> 'inherited' from owner.
>>
>> \dp should return a row fo
- Mail original -
> De: "Albe Laurenz"
> À: "etienne.champet...@free.fr *EXTERN*" ,
> pgsql-general@postgresql.org
> Envoyé: Vendredi 15 Février 2013 13:25:14
> Objet: RE: [GENERAL] Reset permissions on table
>
> etienne champetier wrote:
> &
etienne champetier wrote:
> By default there is no permissions on table (\dp return 0 row)
> If I make a GRANT, doing a REVOKE will not get me in the 'default' state
>
> How to return in the default state, where permission are 'inherited' from
> owner.
\dp should return a row for each table in
y
Hi
By default there is no permissions on table (\dp return 0 row)
If I make a GRANT, doing a REVOKE will not get me in the 'default' state
How to return in the default state, where permission are 'inherited' from owner.
Thanks in advance
--
Sent via pgsql-general mailing list (pgsql-general@p
