Re: [NOVICE] Insert Only Postgresql

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: "Brandon Aiken" <BAiken(at)winemantech(dot)com>
Cc: "Solomon Asare" <solomonasare(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org, karen_hill22(at)yahoo(dot)com
Subject: Re: [NOVICE] Insert Only Postgresql
Date: 2006-09-09 00:39:26
Message-ID: b42b73150609081739j641403e6k6884f8fde9b27d4b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

On 9/8/06, Brandon Aiken <BAiken(at)winemantech(dot)com> wrote:
> 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.

all tables in postgresql have insert, update, and delete rights you
can grant or revoke. If you want to be smart and save time, you can
make a procedure to query information_schema and do this automatically
for you with some dynamic sql [hi, karen!] and just call it whenever
you make new tables.

merlin

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Nolan 2006-09-09 00:54:23 Logging queries that are part of a stored procedure
Previous Message Merlin Moncure 2006-09-09 00:35:27 Re: Stored Procedure performance / elegance question

Browse pgsql-novice by date

  From Date Subject
Next Message Andreas 2006-09-09 02:57:46 Re: hyperlinks stored in pgsql
Previous Message Steve Crawford 2006-09-09 00:11:01 Re: Serial and triggers