Re: "Write once-Read many" table ?
Date: Thu, 28 Feb 2008 03:17:19 -0800 (PST)
On Feb 27, 6:17 pm, Mladen Gogala <mgog..._at_yahoo.com> wrote:
> 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.
The thing is, I am the dba.
I trust myself but that's not enough ;) Received on Thu Feb 28 2008 - 05:17:19 CST