Re: NT user info

From: Richard Nield <richard.nield_at_ntlworld.com>
Date: Wed, 13 Feb 2002 22:14:42 -0000
Message-ID: <jKBa8.59978$H37.7786158@news2-win.server.ntlworld.com>

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 - 16:14:42 CST