Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Capture of DDL Statement
When someone asks for a methodology to allow something that is dangerous or a
license violation it would be irresponsible for someone to help them without
pointing it out.
Howard's response was absolutely appropriate. If you don't like it then consider paying Oracle for a better support contract.
Daniel Morgan
Jerry Metz wrote:
> 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.
> > >
Received on Mon Mar 18 2002 - 14:29:24 CST