From oracle-l-bounce@freelists.org Thu Dec 1 10:57:35 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id jB1GvZwd014703 for ; Thu, 1 Dec 2005 10:57:35 -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 jB1GvRAX014684 for ; Thu, 1 Dec 2005 10:57:27 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E622C23EE30; Thu, 1 Dec 2005 11:54:46 -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 27601-06; Thu, 1 Dec 2005 11:54:46 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6A1DF23E2F1; Thu, 1 Dec 2005 11:54:46 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 01 Dec 2005 11:52:49 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C6FE623E74C for ; Thu, 1 Dec 2005 11:52:49 -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 27061-01 for ; Thu, 1 Dec 2005 11:52:49 -0500 (EST) Received: from smtp1.arraybiopharma.com (smtp1.arraybiopharma.com [65.114.206.101]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3D22F235064 for ; Thu, 1 Dec 2005 11:52:49 -0500 (EST) Received: from ims01bldr.arraybp.com (mail.arraybiopharma.com [10.10.10.37]) by smtp1.arraybiopharma.com (8.12.11/8.12.11) with ESMTP id jB1Gqgjb007892; Thu, 1 Dec 2005 09:52:46 -0700 Received: from fiji.arraybp.com ([10.10.10.215]) by ims01bldr.arraybp.com with Microsoft SMTPSVC(5.0.2195.6713); Thu, 1 Dec 2005 09:52:42 -0700 Priority: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5F697.A54AC504" Subject: RE: Can IP addresses be audited in Oracle Date: Thu, 1 Dec 2005 09:52:42 -0700 Message-ID: <17CAB0BF27BCFC47B0E4554A0E2F962B873817@fiji.arraybp.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Can IP addresses be audited in Oracle Thread-Index: AcX2FGozBSREUOrrQSS1U996Zwk3pwAAW63AAABlLSAAIAt1kA== From: "Reidy, Ron" To: "Randy Samberg" , X-OriginalArrivalTime: 01 Dec 2005 16:52:42.0658 (UTC) FILETIME=[A578D020:01C5F697] X-archive-position: 28818 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Ron.Reidy@arraybiopharma.com Precedence: normal Reply-To: Ron.Reidy@arraybiopharma.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.7 required=5.0 tests=AWL,BAYES_00, HTML_FONTCOLOR_BLUE,HTML_FONTCOLOR_UNSAFE,HTML_MESSAGE autolearn=no version=2.63 ------_=_NextPart_001_01C5F697.A54AC504 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable No. Here is the doc describing this function: =20 http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14200/func tions165.htm#SQLRF06117 =20 -----Original Message----- From: Randy Samberg [mailto:Randy.Samberg@palmsource.com]=20 Sent: Wednesday, November 30, 2005 6:36 PM To: Reidy, Ron; Oracle-L@freelists.org Subject: RE: Can IP addresses be audited in Oracle Thanks for your reply. Can sys_context just be used to get information about the current session, or can it be used to audit other users logged onto the database? =20 Thanks, Randy _____ =20 From: Reidy, Ron [mailto:Ron.Reidy@arraybiopharma.com]=20 Sent: Wednesday, November 30, 2005 5:24 PM To: Randy Samberg; Oracle-L@freelists.org Subject: RE: Can IP addresses be audited in Oracle sys_context will give that information and more. -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Randy Samberg Sent: Wednesday, November 30, 2005 6: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 _____ =20 This electronic message transmission is a PRIVATE communication which contains information=20 which may be confidential or privileged. The information is intended to be for the use of the individual=20 or entity named above. If you are not the intended recipient, please be aware that any disclosure,=20 copying, distribution or use of the contents of this information is prohibited. Please notify the sender=20 of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0),=20 and then delete it from your system.=20 This electronic message transmission is a PRIVATE communication which = contains information which may be confidential or privileged. The information is = intended=20 to be for the use of the individual or entity named above. If you are = not the=20 intended recipient, please be aware that any disclosure, copying, = distribution=20 or use of the contents of this information is prohibited. Please notify = the sender of the delivery error by replying to this message, or notify us = by telephone (877-633-2436, ext. 0), and then delete it from your system. ------_=_NextPart_001_01C5F697.A54AC504 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Message
No.  Here is the doc describing this = function:
 
http://download-west.oracle.com/docs/cd/B= 19306_01/server.102/b14200/functions165.htm#SQLRF06117<= /DIV>
 
-----Original Message-----
From: Randy Samberg=20 [mailto:Randy.Samberg@palmsource.com]
Sent: Wednesday, = November 30,=20 2005 6:36 PM
To: Reidy, Ron; = Oracle-L@freelists.org
Subject:=20 RE: Can IP addresses be audited in Oracle

Thanks for your reply.  Can sys_context = just be=20 used to get information about the current session, or can it be used to = audit=20 other users logged onto the database?
 
Thanks,
Randy


From: Reidy, Ron=20 [mailto:Ron.Reidy@arraybiopharma.com]
Sent: Wednesday, = November 30,=20 2005 5:24 PM
To: Randy Samberg;=20 Oracle-L@freelists.org
Subject: RE: Can IP addresses be = audited in=20 Oracle

sys_context will give that information and = more.
-----Original Message-----
From: = oracle-l-bounce@freelists.org=20 [mailto:oracle-l-bounce@freelists.org] On Behalf Of Randy=20 Samberg
Sent: Wednesday, November 30, 2005 6:13 = PM
To:=20 Oracle-L@freelists.org
Subject: Can IP addresses be audited in = 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
=
 
 


This = electronic=20 message transmission is a PRIVATE communication which contains = information=20
which may be confidential or privileged. The information is intended = to be=20 for the use of the individual
or entity named above. If you are not = the=20 intended recipient, please be aware that any disclosure,
copying,=20 distribution or use of the contents of this information is prohibited. = Please=20 notify the sender
of the delivery error by replying to this message, = or=20 notify us by telephone (877-633-2436, ext. 0),
and then delete it = from your=20 system.
=20


This = electronic message transmission is a PRIVATE communication which = contains information
which may be confidential or privileged. The = information is intended to be for the use of the individual
or = entity named above. If you are not the intended recipient, please be = aware that any disclosure,
copying, distribution or use of the = contents of this information is prohibited. Please notify the sender =
of the delivery error by replying to this message, or notify us by = telephone (877-633-2436, ext. 0),
and then delete it from your = system.

------_=_NextPart_001_01C5F697.A54AC504-- -- http://www.freelists.org/webpage/oracle-l