Re: Capture of DDL Statement

Hopefully, I can put an end to all of this.

Nowhere in my original request did I ever mention the type of database that I wanted this solution for (i.e., production, development, test). And maybe, just maybe, there are factors involved in the decision process of which you and all of the others have no knowledge (i.e., the client wants it that way). If I wanted your opinions, I'm not bashful - I certainly would have requested them (and been highly appreciative for them, as well!) What I wanted and needed (and only received from one person) was the way to accomplish the request that I had outlined. Everybody else felt the necessity to tell me how I (or in this case the client) should rule the database. All of this information was extremely interesting, but nonetheless, useless in this situation.

Please - next time when somebody asks a question, give them the specific answer that they request. After that, if you want to add something more, like providing the wisdom of your experience, feel free.

David Fitzjarrell wrote:

> 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.
> > > >
> >
> > --