RE: Can IP addresses be audited in Oracle

To everyone that answered my email.  

Thank you to everyone for your help and comments.  

Randy

From: Randy Samberg
Sent: Wednesday, November 30, 2005 5:13 PM To: 'Oracle-L_at_freelists.org'
Subject: Can IP addresses be audited in Oracle

Hello guru's,  

Does anyone know if there is any way to get the ip address of someone that is logged into Oracle. My manager wants to audit users logging into our Lawson database running on Oracle. He said he wants user, login time, logout time, and ip address. I know that if you turn on auditing, you can get a login and logout time, but this slows down Lawson, and does not give an ip address. The ip address seems to be the most important thing to him. I looked at all the dynamic views, and none of these give that information. Does anyone have any ideas? Thanks in advance.  

Randy    

--
http://www.freelists.org/webpage/oracle-l