Re: connect and

You have to set the resource limits. You do this in 2 steps, first you have to set the parameter resource_limit=true in your initXXXX.ora file (you'll have to shutdown database and restart). Then you have to limit the logins per user. I do this with a profile I create, set the sessions per user to 1, assign that profile to your user that connects to Oracle.

Opus

Knut Lambert <lambert_at_consilium.de> wrote in message news:7v7cvn$9bd$1_at_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 - 14:40:53 CDT