Re: Automize SQL TRACE OPERATION

Hi Bill,

You can check in the after logon trigger for the username or sid, serial etc. Have a look at a paper i wrote recently that describes many ways to enable trace in Oracle. There is an example of a logon trigger that checks which user is calling it. In my example I just check its not SYS or SYSTEM but you can change that and check in anyway you want. The paper is http://www.petefinnigan.com/ramblings/how_to_set_trace.htm

hth

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.