Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Make table read-only
"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<41742322$0$10347$afc38c87_at_news.optusnet.com.au>...
> My only point here is not to rubbish the idea of before DML triggers,
> because they clearly rule out most DML possibilities. But I'd hate someone
> to rely on it as a means of, say, "guaranteeing" the data is free from all
> changes from this point on, because it's not. I doubt it would pass
> 'archiving' muster with the tax office, for example.
>
> Regards
> HJR
You are correct. The other one I thought about after I posted is the
necessity for a before DDL trigger for "DROP TABLE." At some point,
I'm thinking, what exactly are we doing here?!! ;)
Received on Tue Oct 19 2004 - 07:51:29 CDT