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>


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.com
Received on Wed Feb 27 2008 - 11:17:29 CST

Original text of this message