Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: RESTRICTING DB ACCESS ?
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>...Received on Tue Sep 15 1998 - 00:00:00 CDT
>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
>
![]() |
![]() |