Preventing DELETEs - Mailing list pgsql-sql

From Rajesh Kumar Mallah.
Subject Preventing DELETEs
Date
Msg-id 200209270030.16040.mallah@trade-india.com
Whole thread Raw
Responses Re: Preventing DELETEs  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-sql
Hi ,

I have a created a database and a table in it,

I want to prevent "DELETES" on the table in this
database by everyone except superuser postgres.
even by me (the creator of this database and table)


I have tried in many ways (ALTER TABLE REVOKE DELETE .. etc etc)

but i  always end up with having the permission


can any one tell me how the prevention can be accomplished?

thanks in advance.

regds
mallah.



--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.




pgsql-sql by date:

Previous
From: Andrew Perrin
Date:
Subject: Re: Case Sensitive "WHERE" Clauses?
Next
From: dima
Date:
Subject: Re: Preventing DELETEs