User DB with User NT

[Jorge Pinto]

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

[Jorge Pinto]

I think it's Oracle 8i (8.1)
"s.kapitza" <sk******@volcanomail.com> wrote in message
news:26**************************@posting.google.c om...

hi,

osuser in v$session might what you are after.

the rest depends on your Oracle Version.

regards

s.kapitza

"Jorge Pinto" <jo****@sympatico.ca> wrote in message

news:<mL*******************@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

[Jorge Pinto]

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" <jo****@sympatico.ca> wrote in message
news:mL*******************@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

[Charles]

You can create this user with parameter 'EXTERNAL'. The Oracle
authentication is then passed onto the NT. Therefore, eliminating the need
of creating a trigger.

Charles
"Jorge Pinto" <jo****@sympatico.ca> wrote in message
news:mL*******************@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