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: getting DDL audit to work

Re: getting DDL audit to work

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Tue, 21 Mar 2006 16:06:49 -0500
Message-ID: <0lq022psu21tcogk64ht5iosdgj71iucfq@4ax.com>


On 21 Mar 2006 12:53:17 -0800, "Anurag Varma" <avoracle_at_gmail.com> wrote:

>
>Seems to not be supported.
>It should have been audited when you turn everything on (audit all by
>access;)
>or everything related to a procedure (audit procedure by access;).
>
>However, recompilation is not audited. Only the first create is.

Would you agree that the 'audit alter any procedure' statement would imply it's 'supported' :)

All I want is to monitor DDL changes on the production databases. .......
We run Oracle 9.2.0.6 on RH4 AMD
remove NSPAM to email Received on Tue Mar 21 2006 - 15:06:49 CST

Original text of this message

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