Re: getting login information
From: Neville Sweet <sweet.neville.nj_at_bhp.com.au.no_junk_email>
Date: Thu, 22 Jul 1999 15:12:34 +1000
Message-ID: <7n69lt$oc211_at_atbhp.corpmel.bhp.com.au>
Date: Thu, 22 Jul 1999 15:12:34 +1000
Message-ID: <7n69lt$oc211_at_atbhp.corpmel.bhp.com.au>
Don't know if it will give you IP address, but the v$session table might help.
Bruno Gervasi wrote in message <37962CE7.DDC3F88E_at_nfb.ca>...
>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
>
>
Received on Thu Jul 22 1999 - 07:12:34 CEST