From oracle-l-bounce@freelists.org Thu Dec 1 21:16:09 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id jB23G9uM020891 for ; Thu, 1 Dec 2005 21:16:09 -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 jB23G3AX020878 for ; Thu, 1 Dec 2005 21:16:04 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B22162404B4; Thu, 1 Dec 2005 22:15:56 -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 16150-03; Thu, 1 Dec 2005 22:15:56 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 245D52404A6; Thu, 1 Dec 2005 22:15:56 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 01 Dec 2005 22:14:00 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1332C24035C for ; Thu, 1 Dec 2005 22:14:00 -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 15541-06 for ; Thu, 1 Dec 2005 22:13:59 -0500 (EST) Received: from mx2.palmsource.com (mx2.palmsource.com [12.7.175.14]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8A982240253 for ; Thu, 1 Dec 2005 22:13:59 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by localhost.domain.tld (Postfix) with ESMTP id C7B7622EDF for ; Thu, 1 Dec 2005 19:13:58 -0800 (PST) Received: from mx2.palmsource.com ([127.0.0.1]) by localhost (mx2.palmsource.com [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 13110-03-2 for ; Thu, 1 Dec 2005 19:13:58 -0800 (PST) Received: from ussunex1.palmsource.com (unknown [192.168.101.16]) by mx2.palmsource.com (Postfix) with ESMTP id 002BC22ADE for ; Thu, 1 Dec 2005 19:13:58 -0800 (PST) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5F6EE.6ED59228" Subject: RE: Can IP addresses be audited in Oracle Date: Thu, 1 Dec 2005 19:13:57 -0800 Message-ID: <492F4322B62F3C4CBA5131524867C8E466E2E0@ussunex1.palmsource.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Can IP addresses be audited in Oracle Thread-Index: AcX2FGozBSREUOrrQSS1U996Zwk3pwA2SJfg From: "Randy Samberg" To: X-archive-position: 28841 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Randy.Samberg@palmsource.com Precedence: normal Reply-To: Randy.Samberg@palmsource.com 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.6 required=5.0 tests=AWL,BAYES_00, HTML_FONTCOLOR_BLUE,HTML_FONTCOLOR_UNSAFE,HTML_MESSAGE autolearn=no version=2.63 ------_=_NextPart_001_01C5F6EE.6ED59228 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable To everyone that answered my email. =20 Thank you to everyone for your help and comments. =20 Randy ________________________________ From: Randy Samberg=20 Sent: Wednesday, November 30, 2005 5:13 PM To: 'Oracle-L@freelists.org' Subject: Can IP addresses be audited in Oracle 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_01C5F6EE.6ED59228 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
To everyone that answered my = email.
 
Thank you to everyone for your help and=20 comments.
 
Randy


From: Randy Samberg
Sent: = Wednesday,=20 November 30, 2005 5:13 PM
To:=20 'Oracle-L@freelists.org'
Subject: Can IP addresses be audited = in=20 Oracle

Hello=20 guru's,
 
Does = anyone know if=20 there is any way to get the ip address of someone that is logged into=20 Oracle.  My manager wants to = audit=20 users logging into our Lawson database running on Oracle. =  He=20 said he wants user, login time, logout time, and ip address.  I = know that=20 if you turn on auditing, you can get a login and logout time, but this = slows=20 down Lawson, and does not give an ip address.  The ip address seems = to be=20 the most important thing to him.  I looked at all the dynamic = views, and=20 none of these give that information.  Does anyone have any = ideas? =20 Thanks in advance.
 
Randy
=
 
 
------_=_NextPart_001_01C5F6EE.6ED59228-- -- http://www.freelists.org/webpage/oracle-l