Re: NT user info

Thanks for the version number but it doesn't much matter. The answer is still in v_$session.

Daniel Morgan

Richard Nield wrote:

> Thanks for the replies.....sorry I forgot to mention the oracle version
> ...which is 8i.
>
> Richard
>
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> news:6pol6u4d8v6c99eb495opjml4afk6tvp22_at_4ax.com...
> > On Wed, 13 Feb 2002 21:51:24 GMT, damorgan
> > <dan.morgan_at_ci.seattle.wa.us> wrote:
> >
> > >Have you looked at V_$SESSION? Specifically the osuser, machine, and
> > >terminal fields?
> > >
> > >Daniel Morgan
> > >
> > >
> > >
> > >Richard Nield wrote:
> > >
> > >> Hi - I am trying to create a trigger to monitor who logs on to the
> > >> production user. Is there anyway I can obtain the logged on NT user and
> > >> terminal from dual, or somewhere else?
> > >>
> > >> Many thanks for any help!
> > >>
> > >> Richard
> >
> >
> > He'd be better off looking at the SYS_CONTEXT function in the SQL
> > reference manual. That is, when he is running 8i, which he of course
> > doesn't mention to make things harder for potential responders.
> >
> > Hth
> >
> > Sybrand Bakker, Senior Oracle DBA
> >
> > To reply remove -verwijderdit from my e-mail address
Received on Wed Feb 13 2002 - 17:45:50 CST