Re: Make table read-only

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Tue, 19 Oct 2004 22:56:14 +1000
Message-Id: <41750ee9$0$10347$afc38c87@news.optusnet.com.au>

Steve Howard wrote:

> "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?!!  ;)

Yeah, even putting the table into a read only tablespace won't stop DDL trashing it. Practically, even in R/O tablespace, it will need a before DDL trigger to stop that sort of thing ....so that's a good call, too!

Regards
HJR Received on Tue Oct 19 2004 - 07:56:14 CDT