Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Capture of DDL Statement
I don't recall asking for your value judgment. I asked for a methodology to
complete the task.
"Howard J. Rogers" wrote:
> 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.
> >