Re: Finding IP address of client

From: Neil Chandler <oracle_at_tchp2.tcamuk.stratus.com>
Date: 1998/01/19
Message-ID: <slrn6c6tuq.r18.oracle@tchp2.tcamuk.stratus.com>#1/1

In article <34bfdde6.6509848_at_news.dlc.fi>, Aarre Heikkilä wrote:

V$SESSION Does have the client host name on it, but this is NOT the IP address.

There is a variable USERNAME in the ORACLE.INI (or WIN.INI) on Windows which is passed across to the server. You could make this variable the IP address.

Of course, the user could then manually change the variable to confuse you... Never trust a user to do the things you expect them to...

Neil Chandler

>Hello !
>
>Look view v$session.
>It has clients host names in it.
>
>Aarre Heikkilä
>aarre_at_dlc.fi
>
>On Tue, 13 Jan 1998 23:31:29 -0000, "CompBDO" <binhdo_at_onramp.net>
>wrote:
>
>>Is it possible to dynamically obtain the IP address of client machines
>>connected to Oracle? If so, how is it done?
>>
>>
>
Received on Mon Jan 19 1998 - 00:00:00 CST