Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: RESTRICTING DB ACCESS ?
There is a parameter in the INIT.ORA file for the server that will restrict the number of connections to the server. Off the top of my head I don't recall the name of it though.
In article <35FE869A.17BCBC3A_at_writeme.com>,
JDM <tanx2_at_writeme.com> wrote:
> 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
>
>
-- Bruce Armstrong [TeamPS] Preach the gospel at all times. If necessary, use words.[Francis of Assisi] -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member ForumReceived on Tue Sep 15 1998 - 00:00:00 CDT