Re: How to check with multiple login?

From: joel garry <joel-garry_at_home.com>
Date: Tue, 21 Sep 2010 09:22:25 -0700 (PDT)
Message-ID: <635b36fc-2182-443f-90ef-71caee275c59_at_q21g2000prm.googlegroups.com>

On Sep 21, 1: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?

Why do you want to do this? For most apps I've seen, people love being able to have multiple windows on their display. Sometimes it can be a PITA if you have special serialization requirements, I have a job barcoding time-series app like that which is very touchy about commits, but even so, there are other session variables available to limit what really needs to be limited.

Normally when I hear a request like this there is either some serious misapprehension of multiuser capabilities, or people are worried about the wrong security issues.

jg

--
_at_home.com is bogus.
"45 minutes 'til I go onstage at Moscone West L2 2014: Messed-Up Apps
(3pm). Plz join me. " - Cary Millsap

Received on Tue Sep 21 2010 - 11:22:25 CDT