469,082 Members | 1,152 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,082 developers. It's quick & easy.

User DB with User NT

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
Jul 19 '05 #1
3 2404
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

Jul 19 '05 #2
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

Jul 19 '05 #3
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

Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

60 posts views Thread by Fotios | last post: by
3 posts views Thread by zlst | last post: by
6 posts views Thread by martin | last post: by
2 posts views Thread by rn5a | last post: by
1 post views Thread by Carlettus | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.