Re: Capturing Schema changes ??

From: Mogens Nørgaard <mln_at_miracleas.dk>
Date: Mon, 12 Jul 2004 11:30:49 +0200
Message-ID: <40F25A49.7010704@miracleas.dk>

Setting DML_LOCKS to 0 could also stop it :-).

Would FGA be an option here?

Mogens

Stephane Faroult wrote:

>
> George,
>
> If you really want details about what has truly occurred (instead of
> recording that *something* has occurred), I think that DDL triggers are the
> way to go (I don't think that audit has much evolved since at least the days
> of Oracle 5 ...). Beware though that some DDL statements fire several
> triggers (eg ALTER TABLE ... ADD CONSTRAINT ... PRIMARY KEY ... if no index
> to enforce the constraint already exists). But for the more trivial cases,
> it can become tricky.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon Jul 12 2004 - 04:27:26 CDT