Home > mailing lists

REVOKE "ALL FROM ALL" - Mailing list pgsql-general

From	Knut P. Lehre
Subject	REVOKE "ALL FROM ALL"
Date	July 6, 2007 14:54:57
Msg-id	fc9d981a41d7.468e65c0@broadpark.no Whole thread Raw
List	pgsql-general

Tree view

Is the following a safe way to revoke all rights from all users and groups on a table or view (TABLEORVIEWNAME)?
update pg_class set relacl=null where relname='TABLEORVIEWNAME';

pgsql-general by date:

From: Perry Smith
Date: 06 July 2007, 13:56:48
Subject: Re: Polymorphic delete help needed

From: "Sibte Abbas"
Date: 06 July 2007, 15:04:55
Subject: Re: DB crashed and duplicated template0 db

REVOKE "ALL FROM ALL" - Mailing list pgsql-general

Previous

Next