[Info-Ingres] TRACING PROCEDURES

[Jean-Pierre Zuate]

Hello,

Yes with security audit you can audit procedures create, drop and execution
(enable security_audit procedure)

Extract from SQL Reference Guide :
PROCEDURE
Logs all access to database procedures (create procedure and drop procedure
statements and procedure execution) by all users.

Hope this help,
Jean-Pierre

2007/4/27, Karl & Betty Schendel <schendel at kbcomputer.com>:
>
> At 6:27 AM -0700 4/27/07, npiet at gascognelaminates.com wrote:
> >Does anyone know how to trace the execution of dbms
> >procedures ? We would like to trace the queries in a procedure.
> >
>
> You can't, at least not in any reasonable manner.
>
> It might be possible to get some idea of what's happening
> by turning on security auditing;  I'm not sure, I've never
> tried it.  There is no printqry-like way to do it, though.
>
> Karl
> _______________________________________________
> Info-Ingres mailing list
> Info-Ingres at kettleriverconsulting.com
> http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres
>



-- 
Jean-Pierre Zuate
La Fage Conseil
+33(0)6 11 40 11 09
jpzuate at gmail.com
http://www.ingres-ua.fr/sponsors/la-fage-conseil/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.kettleriverconsulting.com/mailman/private/info-ingres/attachments/20070427/a34c2e4c/attachment.html