Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Make table read-only

Re: Make table read-only

From: Steve Howard <stephen.howard_at_us.pwcglobal.com>
Date: 19 Oct 2004 05:51:29 -0700
Message-ID: <6d8b7216.0410190451.132406b8@posting.google.com>


"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US