Re: alter session set sql_trace inside a procedure

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.