Re: alter session set sql_trace inside a procedure

"Pete Finnigan" <plsql_at_petefinnigan.com> wrote in message news:DGLQ56A4sYTARxLq_at_peterfinnigan.demon.co.uk...
> Hi Flavio,
>
> I find it hard to see how you can do your job if you are not allowed
> access to trace packages and also to the trace files that you generate.
>
> If this situation persists then probably your best option is to have a
> procedure that uses alter session as you suggest and use a flag to turn
> it on. This could be dbms_alert, dbms_pipe or even just create a table
> with a flag in it and change the value of the flag before you run the
> batch processes.
>
> kind regards
>
> Pete
> --
> Pete Finnigan
> email:pete_at_petefinnigan.com
> Web site: http://www.petefinnigan.com - Oracle security audit specialists
> Book:Oracle security step-by-step Guide - see http://store.sans.org for
details.

Thank you for the tip Pete!
If I can't use dbms_alter I'll stick to the custom table, it's the easier option I think.

Bye,
Flavio Received on Tue Mar 09 2004 - 12:59:44 CST