Re: Capture of DDL Statement

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Mon, 18 Mar 2002 17:50:56 +1100
Message-ID: <a742pk$85m$1@lust.ihug.co.nz>

For 9i, you're wasting your time. All DDL statements are included in the redo logs already, and judicious use of Log Miner will reveal precisely who did what, to what, and at what time.

For anything other than 9i, then yes, triggers are the way to go... but honestly, do you really allow "any and all users" to issue DDL? Yikes.... my spine is tingling at the mere thought.

Regards
HJR

--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================


"Jerry Metz" <JMetz1_at_ix.netcom.com> wrote in message
news:3C9509CC.646536E0_at_ix.netcom.com...


> I want to be able to capture in a database trigger all of the changes

> made to the database schemas by any and all users.  As a part of that, I

> can get the user_id, the object name, object type, and schema with no

> problem via sys.dictionary_obj...

>

> I am running both Oracle9i and Oracle8i Enterprise (on separate

> machines).

>

> Does anyone have any ideas on how to capture the actual ddl statement

> (either before or after it is sent to the database)?

>

> PS - I've looked in all of the manuals that I have, so, if you are going

> to send me back to the manuals for further reference checking, please

> point me to the appropriate manual to look at.  Thanks.

>

Received on Mon Mar 18 2002 - 00:50:56 CST