Postgres Pro
Downloads
Home   >   mailing lists

Re: about rules - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: about rules
Date
Msg-id 420B55E4.7020001@familyhealth.com.au
Whole thread Raw
In response to about rules  (prashant sangale <prashant_sangale@yahoo.com>)
List pgsql-hackers
Tree view 
> How to write a rule to avoid queries like update,insert,delete,select 
> from any database users except superuser.  

REVOKE UPDATE,INSERT,DELETE,SELECT ON table FROM PUBLIC, other users;

Chris

pgsql-hackers by date:

Previous
From: prashant sangale
Date:
Subject: about rules
Next
From: Andreas Pflug
Date:
Subject: Re: How can I use large object on PostgreSQL Linux