Re: "Write once-Read many" table ?
From: Mladen Gogala <mgogala_at_yahoo.com>
Date: 27 Feb 2008 18:17:29 +0100
Message-ID: <47c59b29$1@news.x-privat.org>
Date: 27 Feb 2008 18:17:29 +0100
Message-ID: <47c59b29$1@news.x-privat.org>
On Wed, 27 Feb 2008 07:16:05 -0800, jm.scheiwiler wrote:
> Hello,
>
> For legal reasons, we would like to create tables where one can insert,
> select but never never delete nor update.
>
> I know we can prevent delete and update with revoke grants or with
> triggers but this is not satisfactory because grants can be re-granted
> and triggers can be dropped.
You have to trust your DBA. That's the bottom line.
-- http://mgogala.freehostia.comReceived on Wed Feb 27 2008 - 11:17:29 CST