Re: User DB with User NT

From: Jorge Pinto <jorgep_at_sympatico.ca>
Date: Wed, 25 Jun 2003 21:54:25 -0700
Message-ID: <wnsKa.5203$OE2.603207_at_news20.bellglobal.com>


My real case is I have a trigger that checks the time that the user is trying to connect the db and depends on it, I reply to the user's email an error and the user is not allowed to connect to it.... The user'smail is the same as his/her login on NT!!!

Thanks in advance....

"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:54:25 CEST

Original text of this message