Preventing DELETEs

From: "Rajesh Kumar Mallah(dot)" <mallah(at)trade-india(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Preventing DELETEs
Date: 2002-09-26 19:00:16
Message-ID: 200209270030.16040.mallah@trade-india.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message dima 2002-09-26 19:00:26 Re: Preventing DELETEs
Previous Message Andrew Perrin 2002-09-26 18:22:55 Re: Case Sensitive "WHERE" Clauses?