Re: "Write once-Read many" table ?

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.
>
> --http://mgogala.freehostia.com

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