Re: How to check with multiple login?

From: Mladen Gogala <no_at_email.here.invalid>
Date: Tue, 21 Sep 2010 15:06:36 +0000 (UTC)
Message-ID: <pan.2010.09.21.15.06.35_at_email.here.invalid>

On Tue, 21 Sep 2010 01:50:40 -0700, Mullin Yu 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?

You can use resource limits and set sessions_per_user in create/alter profile statement.

-- 
http://mgogala.byethost5.com

Received on Tue Sep 21 2010 - 10:06:36 CDT