Re: Reset permissions on table

----- Mail original -----
> De: "Albe Laurenz" <laurenz.albe@wien.gv.at>
> =C3=80: "etienne.champetier@free.fr *EXTERN*" <etienne.champetier@free.fr=
>, pgsql-general@postgresql.org
> Envoy=C3=A9: Vendredi 15 F=C3=A9vrier 2013 13:25:14
> Objet: RE: [GENERAL] Reset permissions on table
>=20
> 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
> >=20
> > How to return in the default state, where permission are
> > 'inherited' from owner.
>=20
> \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 ...)

>=20
> I assume that you are referring to the empty
> "Access privileges" column.
>=20
> After granting and revoking a privilege, the value
> showd be "owner=3DarwdDxt/owner" (where "owner" is
> the user that owns the table).
>=20
> This is the default value: the owner has all
> privileges and nobody else has any.
>=20
> 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 the=
re is explicit right.

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