REVOKE "ALL FROM ALL"

From: "Knut P(dot) Lehre" <knutpl(at)broadpark(dot)no>
To: pgsql-general(at)postgresql(dot)org
Subject: REVOKE "ALL FROM ALL"
Date: 2007-07-06 13:54:40
Message-ID: fc9d981a41d7.468e65c0@broadpark.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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';

Browse pgsql-general by date

  From Date Subject
Next Message Perry Smith 2007-07-06 13:57:41 Re: Polymorphic delete help needed
Previous Message Alvaro Herrera 2007-07-06 13:49:28 Re: Nested Transactions in PL/pgSQL