RE: Can IP addresses be audited in Oracle
- From: "Janardhana Donga" <jbdonga@xxxxxxxxxxx>
- To: <Randy.Samberg@xxxxxxxxxxxxxx>, <Oracle-L@xxxxxxxxxxxxx>
- Date: Thu, 1 Dec 2005 09:38:34 -0800
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Randy Samberg
Sent: Wednesday, November 30, 2005 5:13 PM
To: Oracle-L@xxxxxxxxxxxxx
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
Other related posts:
