Re: Capture of DDL Statement

Nothing like a good bitch fight to clear the air! ;-)

After all that, hope the original post got answered.

M

damorgan <damorgan_at_exesolutions.com> wrote in message news:<3C967756.3C805D45_at_exesolutions.com>...
> 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 Wed Mar 20 2002 - 08:53:06 CST