Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Can IP addresses be audited in Oracle

Re: Can IP addresses be audited in Oracle

From: jame tong <>
Date: Thu, 1 Dec 2005 14:26:09 +0800
Message-ID: <>

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

On 12/1/05, Randy Samberg <> wrote:
> 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?
> Thanks,
> Randy
> ------------------------------
> *From:* Reidy, Ron []
> *Sent:* Wednesday, November 30, 2005 5:24 PM
> *To:* Randy Samberg;
> *Subject:* RE: Can IP addresses be audited in Oracle
> sys_context will give that information and more.
> -----Original Message-----
> *From:* [mailto:
>] *On Behalf Of *Randy Samberg
> *Sent:* Wednesday, November 30, 2005 6:13 PM
> *To:*
> *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*
> ------------------------------
> 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.

Received on Thu Dec 01 2005 - 00:28:19 CST

Original text of this message