Re: Capture of DDL Statement

You are putting way too much emotion into this. No one cares whether you take a blow-torch to the darned machine. It was a very reasonable caution to which you have over-reacted.

I support Howard in his response to you and I would have given you roughly the same answer if I had responded first. No doubt we will continue to do what we do exactly as we have been doing it (what with not getting paid for our time) and you, and others, can either accept the advice as it comes or go elsewhere (because you aren't paying for it).

This is the usenet ... if you would rather deal with people who are paid to keep their opinions to themselves ... next time post your question at http://metalink.oracle.com.

Daniel Morgan

Jerry Metz wrote:

> 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.
> > > > >
> > >
> > > --
Received on Mon Mar 18 2002 - 17:24:58 CST