Re: How to check with multiple login?
From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Tue, 21 Sep 2010 07:28:12 -0700 (PDT)
Message-ID: <872e596c-e06f-48d6-a9ba-ac4441157153_at_t3g2000vbb.googlegroups.com>
On Sep 21, 4:50 am, Mullin Yu <mullin..._at_gmail.com> wrote:
> I have an application and those user accounts are application users,
> not database users, i.e. userid and password stored on the user table
> (e..g usr_user).
>
> Now, I would like to check with any multiple login of users (same
> machine or another user) and in case having, the application will warn
> the user and not allow further login.
>
> Currently, I think of checking with V$session. But then, may need to
> set the value of user id when user logins to the application.
>
> Is it possbile and any information can be shared?
Date: Tue, 21 Sep 2010 07:28:12 -0700 (PDT)
Message-ID: <872e596c-e06f-48d6-a9ba-ac4441157153_at_t3g2000vbb.googlegroups.com>
On Sep 21, 4:50 am, Mullin Yu <mullin..._at_gmail.com> wrote:
> I have an application and those user accounts are application users,
> not database users, i.e. userid and password stored on the user table
> (e..g usr_user).
>
> Now, I would like to check with any multiple login of users (same
> machine or another user) and in case having, the application will warn
> the user and not allow further login.
>
> Currently, I think of checking with V$session. But then, may need to
> set the value of user id when user logins to the application.
>
> Is it possbile and any information can be shared?
How do you plan to use v$session when the users are logging on via an application user and so all have the same Oracle username? Does the application use dbms_application_info to inform Oracle of the real end user? Does the application use connection pooling?
If you can modify the applicaiton code it should be fairly easy via the application to track logon's/user sessions.
Perhaps you can explain what you want a little more clearly.
HTH -- Mark D Powell -- Received on Tue Sep 21 2010 - 09:28:12 CDT