RE: Can IP addresses be audited in Oracle

Try this,  

Set linesize 132

col ip_address format a15

col os_username format a11

col username format a16

col terminal format a15

col comment_text format a89

select os_username,

       username,

       terminal,

       timestamp,

       logoff_time,  

RPAD(substr(comment_text,instr(comment_text,'=',1,3)+1,instr(comment_tex t,')',1,2) - instr(comment_text,'=',1,3) 1),15) IP_ADDRESS,

       sessionid

from dba_audit_trail;  

• Janardhana

  ---

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of 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