Re: ON-LOGON

Jim W wrote:

> 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
> >
> >

I think "Get_Application_property" Built In will help...

Pradhan Received on Tue Jun 02 1998 - 00:41:15 CDT