From oracle-l-bounce@freelists.org Thu Dec 1 11:40:46 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id jB1Hek38020958 for ; Thu, 1 Dec 2005 11:40:46 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id jB1HedAX020940 for ; Thu, 1 Dec 2005 11:40:39 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A39C623F145; Thu, 1 Dec 2005 12:40:32 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 05911-07; Thu, 1 Dec 2005 12:40:32 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2101D23EB0B; Thu, 1 Dec 2005 12:40:32 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 01 Dec 2005 12:38:36 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D005923F151 for ; Thu, 1 Dec 2005 12:38:36 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 05535-01 for ; Thu, 1 Dec 2005 12:38:36 -0500 (EST) Received: from mx3.ucdavis.edu (mx3.ucdavis.edu [169.237.104.13]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 68CAE23E805 for ; Thu, 1 Dec 2005 12:38:36 -0500 (EST) Received: from VEXBE1.ex.ad3.ucdavis.edu (exbe1.ucdavis.edu [169.237.229.68]) by mx3.ucdavis.edu (8.13.3/8.13.1/it-defang-5.4.0) with ESMTP id jB1HcYYh015126; Thu, 1 Dec 2005 09:38:34 -0800 (PST) X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5F69E.0D77F413" Subject: RE: Can IP addresses be audited in Oracle Date: Thu, 1 Dec 2005 09:38:34 -0800 Message-ID: <78BCB579CADE3F4BADFA4813170C4AC5253B13@VEXBE1.ex.ad3.ucdavis.edu> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Can IP addresses be audited in Oracle Thread-Index: AcX2FGozBSREUOrrQSS1U996Zwk3pwAiYTxg From: "Janardhana Donga" To: , X-Scanned-By: MIMEDefang 2.49 on 169.237.104.13 X-archive-position: 28820 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jbdonga@ucdavis.edu Precedence: normal Reply-To: jbdonga@ucdavis.edu X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-4.4 required=5.0 tests=BAYES_00,HTML_60_70, HTML_FONTCOLOR_BLUE,HTML_FONTCOLOR_UNKNOWN,HTML_FONTCOLOR_UNSAFE, HTML_MESSAGE autolearn=no version=2.63 ------_=_NextPart_001_01C5F69E.0D77F413 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Try this, =20 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, =20 RPAD(substr(comment_text,instr(comment_text,'=3D',1,3)+1,instr(comment_te= x t,')',1,2) - instr(comment_text,'=3D',1,3) 1),15) IP_ADDRESS, sessionid from dba_audit_trail; =20 -- Janardhana =20 =20 ________________________________ From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Randy Samberg Sent: Wednesday, November 30, 2005 5:13 PM To: Oracle-L@freelists.org Subject: Can IP addresses be audited in Oracle =20 Hello guru's, =20 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. =20 Randy =20 =20 ------_=_NextPart_001_01C5F69E.0D77F413 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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,'=3D',1,3)+1,instr(comment_te= xt,')',1,2) - instr(comment_text,'=3D',1,3) 1),15) = IP_ADDRESS,

      = sessionid

from = dba_audit_trail;

 

-- = Janardhana

 

 


From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] = On Behalf Of Randy Samberg
Sent: Wednesday, November = 30, 2005 5:13 PM
To: = Oracle-L@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

 

 

------_=_NextPart_001_01C5F69E.0D77F413-- -- http://www.freelists.org/webpage/oracle-l