about rules

Started by prashant sangalealmost 21 years ago2 messages

prashant_sangale@yahoo.com

almost 21 years ago

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'

chriskl@familyhealth.com.au

almost 21 years ago

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