RE: Can IP addresses be audited in Oracle

From: Jesse, Rich <Rich.Jesse_at_quadtechworld.com>
Date: Thu, 1 Dec 2005 10:52:10 -0600
Message-ID: <FB5D3CCFCECC2948B5DCF4CABDBE6697545C2D@QTEX1.qg.com>

Don't forget your friendly flatfile listener.log, which in recent versions of Oracle can be setup as an external table to be read from the DB directly. Because of the nature of the listener, it can't know if a connection is successful or not, just that one was attempted.  

Also note that all bets are off for just about any useful logging information if the client is using JDBC thin to connect.  

Rich

	-----Original Message-----
	From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ethan Post
	Sent: Thursday, December 01, 2005 10:20 AM
	To: jametong_at_gmail.com
	Cc: Oracle-L_at_freelists.org
	Subject: Re: Can IP addresses be audited in Oracle
	
	
	I believe the hostname or IP is in DBA_AUDIT_TRAIL when you

AUDIT SESSION. This is the only way to get the info for a failed logon attempt AFAIK.                  

        On 12/1/05, jame tong <jametong_at_gmail.com> wrote:

                you can use logon triggers to record the context of the logon event.                                                   

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

Received on Thu Dec 01 2005 - 10:57:05 CST