Re: ON-LOGON

From: Jim W <J.Wood.LAB_at_dial.pipex.com>
Date: Mon, 1 Jun 1998 14:32:59 +0100
Message-ID: <6kuajf$886$1@plug.news.pipex.net>

You can select most of this sort of info from v$session. The columns I would imagine you might need are username, osuser, machine and program.

The machine column will tell you the host name, ie the name associated to that IP address - a PC or Unix server etc.

Hope this helps

Jim

Dave S wrote in message <6kq5ho$82o$1_at_tor-nn1.netcom.ca>...
>Hello,
>
>Does anybody know of any command that can be issued from within an ON-LOGON
>trigger that would allow me to find out what userid was used to log on to a
>perticular computer?
>
>For instance, if someone's login was dsingh/<password>, I want to be able
>to find out that the userid for this person running this program is
>'dsingh'.
>
>Thank you for your assistance.
>
>Dave
>
>
Received on Mon Jun 01 1998 - 08:32:59 CDT