Re: User DB with User NT

From: s.kapitza <skapitza_at_volcanomail.com>
Date: 25 Jun 2003 11:01:55 -0700
Message-ID: <26703915.0306251001.3b8c72da_at_posting.google.com>


hi,

osuser in v$session might what you are after.

the rest depends on your Oracle Version.

regards

s.kapitza

"Jorge Pinto" <jorgep_at_sympatico.ca> wrote in message news:<mL7Ka.3056$Fe3.536108_at_news20.bellglobal.com>...
> Hey folks,
>
> I have an user A connected to database DB. On NT this user is logged as B.
> So, I want to create a trigger to see when the user tries to connect the
> database, it checks to see if user connection and user logged on NT is the
> same.
>
> Do I have a variable that returns my user logged on NT ?
> My set variables has the user connect on NT, so is there any possibility to
> read this variable on the server ??
>
> Thanks in advance,
>
> JP
Received on Wed Jun 25 2003 - 20:01:55 CEST

Original text of this message