RE: login auditing

From: Goulet, Richard <>
Date: Thu, 11 Dec 2008 15:22:18 -0500
Message-ID: <>

Use a on logon database trigger. Or use the userhost or terminal columns in sys.aud$.  

Dick Goulet
Senior Oracle DBA
PAREXEL International
 information transmitted in this communication is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please destroy any copies, contact the sender and delete the material from any computer.  

[] On Behalf Of Steiner, Randy Sent: Thursday, December 11, 2008 2:15 PM To:
Subject: login auditing  

I am currently auditing logins and the audit logs are going directly to a syslog server.

We have an application that maintains its own security and logs into Oracle with an application id (app_user).

Oracle is capturing these logins as for app_user. Is there someway I can use sys_context( 'USERENV' , 'OS_USER' ) to have auditing record the OS user login instead of app_user?  



Received on Thu Dec 11 2008 - 14:22:18 CST

Original text of this message