about rules

Started by prashant sangalealmost 21 years ago2 messages
#1prashant sangale
prashant_sangale@yahoo.com

How to write a rule to avoid queries like update,insert,delete,select from any database users except superuser.

thanks,
Prashant

---------------------------------
Do you Yahoo!?
Yahoo! Search presents - Jib Jab's 'Second Term'

#2Christopher Kings-Lynne
chriskl@familyhealth.com.au
In reply to: prashant sangale (#1)
Re: about rules

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