Re: User DB with User NT
Date: Wed, 25 Jun 2003 21:49:53 -0700
Message-ID: <gjsKa.5202$OE2.602381_at_news20.bellglobal.com>
I think it's Oracle 8i (8.1)
"s.kapitza" <skapitza_at_volcanomail.com> wrote in message
news: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 Thu Jun 26 2003 - 06:49:53 CEST