Re: Is the client IP address available
Date: 2000/03/28
Message-ID: <Ni1E4.5977$Dd2.251158_at_stones>#1/1
Try select username , program , terminal , machine from v$session;
It may show up the host name, and a call to gethostbyname should translate
the machine name/terminal name to an I.P. address - although in a DHCP
network, recording the I.P. address will probably give red herrings
somewhere down the line when the IP address lease expires and a new one is
issued to the same client.
Storing the host name and not I.P. address might go someway to resolving
this.
You may have to use explicit grants to the underlying tables or run the query as SYS, sorry to be so vague.
Regards
Adrian
"Kevin Wise" <Kevin.Wise_at_motorola.com> wrote in message
news:8booah$ia6$1_at_schbbs.mot.com...
> Is there any way to determine the IP address of the client from PL/SQL or
> Java? I am trying to write a trigger that records the IP address where
> certain changes are coming from. Thanks!
>
>
Received on Tue Mar 28 2000 - 00:00:00 CEST