Re: getting login information
From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 22 Jul 1999 20:51:19 +0800
Message-ID: <379713C7.782A_at_yahoo.com>
Date: Thu, 22 Jul 1999 20:51:19 +0800
Message-ID: <379713C7.782A_at_yahoo.com>
Bruno Gervasi wrote:
>
> Hi,
>
> How would I get the login information like username, form using, ip
> address where user is logging in to? I have an SQL script which gets
> most info but the ip address of where user is logging in from.
>
> The tables I am using are fnd_logins, fnd_user, fnd_login_respons. and
> so on. But I cannot find IP anywhere.
>
> If you do a ptree of the process you get the ip address eg.
>
> f45runw webfile=6,1700,172.16.0.60
>
> can anyone give me some info.
>
> mailto:B.Gervasi_at_nfb.ca
v$session
v$process
-- =========================================== Connor McDonald "These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com "Some days you're the pigeon, and some days you're the statue."Received on Thu Jul 22 1999 - 14:51:19 CEST