RE: Can IP addresses be audited in Oracle

No. Here is the doc describing this function:  

http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14200/func tions165.htm#SQLRF06117  

-----Original Message-----

From: Randy Samberg [mailto:Randy.Samberg_at_palmsource.com] Sent: Wednesday, November 30, 2005 6:36 PM To: Reidy, Ron; Oracle-L_at_freelists.org
Subject: RE: Can IP addresses be audited in Oracle

Thanks for your reply. Can sys_context just be used to get information about the current session, or can it be used to audit other users logged onto the database?  

Thanks,
Randy

From: Reidy, Ron [mailto:Ron.Reidy_at_arraybiopharma.com] Sent: Wednesday, November 30, 2005 5:24 PM To: Randy Samberg; Oracle-L_at_freelists.org Subject: RE: Can IP addresses be audited in Oracle

sys_context will give that information and more.
-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Randy Samberg Sent: Wednesday, November 30, 2005 6: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    

This electronic message transmission is a PRIVATE communication which contains information
which may be confidential or privileged. The information is intended to be for the use of the individual
or entity named above. If you are not the intended recipient, please be aware that any disclosure,
copying, distribution or use of the contents of this information is prohibited. Please notify the sender
of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0),
and then delete it from your system.

This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.

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