connect and

From: Knut Lambert <lambert_at_consilium.de>
Date: Wed, 27 Oct 1999 19:32:49 +0200
Message-ID: <7v7cvn$9bd$1@newsread.do.de.uu.net>

Hello,

in an application, i have to ensure, that a user can connect only one time to the instance. (Oracle 7 and 8, Windows-NT) How can i do this?

i have created a user with

CREATE PROFILE PR_SIMSUSR
-- all Parameters to default
SESSIONS_PER_USER 1
blah blah blah;

and

CREATE USER "XXX"
blah blah blah
PROFILE PR_SIMSUSR
blah blah blah;

But, i still can connect multiple times.

In my application i am looking to V$SESSION to verify if there is already a session.
But when the connection wents down (e.g. Network Problems) the View shows a Session (Action 100 - LOGON).

What can i do to solve this problem?

Thanks a lot for your help!

Knut Lambert
(lambert_at_consilium.de) Received on Wed Oct 27 1999 - 12:32:49 CDT