"charlie cs" <cs3526(no-spam)@yahoo.com> said...
> Guys,
>
> Is there any way to detect if a java application is hitting the db using a
> stored proc vs. a
> straight sql statement? We'd like to identify what sql we are getting that
> is not in a stored proc. so we can change the Java code.
>
> Any suggestions will be highly appreciated
>
You could add functionality to the stored procedure to write an audit
record to another table whenever it's called. You could write a trigger
against the table(s) that writes an audit record, including the user who
fired the trigger.
--
/Karsten
DBA > retired > DBA
Received on Fri Apr 25 2003 - 10:59:21 CDT
