Which you received, in spades, from Howard and others. However, you
MUST admit that allowing anyone to execute DDL in a database is
frightening, which was the thrust of Howard's comment. That you chose
to take it as a value judgement against yourself is unfortunate, as I
can imagine it wasn't intended as such.
Jerry Metz <JMetz1_at_ix.netcom.com> wrote in message news:<3C95DB91.829B7CC_at_ix.netcom.com>...
> 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 - 15:58:45 CST
