Re: Capturing SQL for a Specific User - How?

You can use the TRACE facility to examine the sql statements....Check out Sql_Trace in your docs....

Ray Cruz <rcruz_at_totcon.com> wrote:

>Anyone know of a way to capture all SQL for a specific user? I realize
>that there is 3rd party software available to do this. However, my
>understanding is that this information can be pulled from the system
>tables. (BTW: I've looked at AUDIT and it doesen't seem to provide
>enough detail such as the actual SQL statement and the columns used for
>the "WHERE" condition).
>
>Can anyone help?
>
>Thanks!

To reply please remove the 'nospam' part of the address Received on Wed Sep 30 1998 - 09:47:35 CDT