Re: RESTRICTING DB ACCESS ?

From: Terry Dykstra [TeamPS] <no_spam_tdykstra_at_cfol.ab.ca>
Date: 1998/09/15
Message-ID: <35feb310.0_at_news.cadvision.com>#1/1


Opening a new window in PB doesn't create another session, unless you use multiple Transaction Objects. You can limit a user to a maximum number of connections using parameters in the init.ora file: license_max_sessions. You can set license_max_users to limit the actual number of userids created. Another option is to create user profiles and set the sessions_per_user parameter.

--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.

JDM wrote in message <35FE869A.17BCBC3A_at_writeme.com>...

>Hi !
>
>We are making a MDI program in PowerBuilder 6.0 using an Oracle 8.0 DB.
>The aim is now to restrict the access to a predefined number of users,
>by the mean of some Oracle features ... if possible.
>
>Given that a new transaction is initiated by a user when he opens a new
>window,
>the restriction cannot be made on the number of DB connections.
>
>How is it then possible to take into account the number of simultaneous
>logged users in order to avoid a number of users greater than the
>predefined one ?
>
>By the use of some Oracle system tables ?
>
>Tanx for any answer ! mailto:tanx2_at_writeme.com
>
Received on Tue Sep 15 1998 - 00:00:00 CEST

Original text of this message