By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,241 Members | 733 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,241 IT Pros & Developers. It's quick & easy.

User DB with User NT

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
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

P: n/a
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

P: n/a
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.