Help me ! Only one session per user

From: Emanuele Carrai <carrai_at_mail.eng.it>
Date: Thu, 12 Oct 2000 12:21:58 +0200
Message-ID: <8s42re$gtb$1@fe2.cs.interbusiness.it>

Hi,
Sorry for my English.

I need to improve security in my database. I want that an user can connect to database " only once independently " from the application used.

I have set MAX_SESSION_PER_USER = 1 but, sometimes, when an error occurs, user stay connected and, even if session is killed, they can't connect again until session are completely cleaned.

So I would like to remove this parameter and use something else, maybe checking Oracle Data Dictionary...

Are other ways to perform this check by oracle server? (Using triggers on v$session ?)

Thanks to all in advance.

Emanuele Carrai Received on Thu Oct 12 2000 - 05:21:58 CDT