Re: Reset permissions on table

----- Mail original -----
> De: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
> À: "etienne(dot)champetier(at)free(dot)fr *EXTERN*" <etienne(dot)champetier(at)free(dot)fr>, pgsql-general(at)postgresql(dot)org
> Envoyé: Vendredi 15 Février 2013 13:25:14
> Objet: RE: [GENERAL] Reset permissions on table
>
> 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
> your search_path.

Sorry, i meant \dp <table-name> and it effectively return 1 row per table (mistype ...)

>
> I assume that you are referring to the empty
> "Access privileges" column.
>
> After granting and revoking a privilege, the value
> showd be "owner=arwdDxt/owner" (where "owner" is
> the user that owns the table).
>
> This is the default value: the owner has all
> privileges and nobody else has any.
>
> It does not matter if the ACL is left empty
> (it contains a NULL value initially) or if
> it contains the default explicitly.

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.

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