Re: [NOVICE] Insert Only Postgresql

["Brandon Aiken" <BAiken@xxxxxxxxxxxxxxx>]

Sure.  Any RDBMS can do that.  Just create a user account (login role for PostgreSQL) and only grant the INSERT privilege to them on your tables, then connect with that account with your program.  Any DELETE or UPDATE statements will automatically fail.

 

--

Brandon Aiken

CS/IT Systems Engineer

---

From: pgsql-novice-owner@xxxxxxxxxxxxxx [mailto:pgsql-novice-owner@xxxxxxxxxxxxxx] On Behalf Of Solomon Asare
Sent: Friday, September 08, 2006 4:51 PM
To: pgsql-novice@xxxxxxxxxxxxxx
Subject: [NOVICE] Insert Only Postgresql

 

Hi All,
pls, is there an Insert only version of postgreql or any other known database? NO deletes, no updates. Inserts only! Any leads, please?

Best Regards,
solomon.