Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Logon Trigger for SQL TRACING using (Third party tool)

Re: Logon Trigger for SQL TRACING using (Third party tool)

From: Pete Finnigan <plsql_at_petefinnigan.com>
Date: Thu, 11 Mar 2004 19:12:50 +0000
Message-ID: <E1+hl3AyoLUARxBC@peterfinnigan.demon.co.uk>


Hi Bill,

let me get this straight. you want to trace the use of a third party tool in your organisation? - do the users of this tool logon with different database ID's - can you identify each session? - i guess probably. If all users used the same database id then you could check for IP address of the client or if possible use dbms_application_info to set the client_info field visible in v$session. So you could use your logon trigger and in that trigger select sid,serial#,username, os PID, IP address if needed. You could have a table with every users name in it and their IP or whatever and a flag to say whether you want to trace them or not. Then you just update that flag as needed. You can then check the flag for the current user and set trace with alter session set events....

To read the trace take a look at my paper http://www.petefinnigan.com/ra mblings/how_to_set_trace.htm - it describes how to find the directory your trace files will be in. In your trigger you could save the ospid to a logging table along with the date/time, username sid serial# etc and then use this information to find the correct trace file.

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.
Received on Thu Mar 11 2004 - 13:12:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US