Re: about rules

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: prashant sangale <prashant_sangale(at)yahoo(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: about rules
Date: 2005-02-10 12:39:00
Message-ID: 420B55E4.7020001@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> 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

In response to

  • about rules at 2005-02-10 12:35:58 from prashant sangale

Browse pgsql-hackers by date

  From Date Subject
Next Message Andreas Pflug 2005-02-10 13:08:42 Re: How can I use large object on PostgreSQL Linux
Previous Message prashant sangale 2005-02-10 12:35:58 about rules