Re: How to restrict the user connections

Ok... Is this a specific set of users or the first 20 that happen to connect? What functionality do you want that license_max_sessions does not currently provide? i.e. I'm currently using license_max_sessions but it causes me problem X and I'd like to find something better because I need to be able to provide Y and license_max_sessions does not allow me to do this...

Tim

Senthil Kumar wrote:

>Hi Tim,
>
>This is to test our internal applications. We don't want to allow all the
>users to access the web application all the time. In some time period we
>want to give access to only 15-20 users.
>
>Now I'm using license_max_sessions, I want to know any other way to do this
>better.
>
>Regards,
>Senthil.
>
>-----Original Message-----
>From: oracle-l-bounce_at_freelists.org
>[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Tim Johnston
>Sent: Thursday, March 18, 2004 8:43 PM
>To: oracle-l_at_freelists.org
>Subject: Re: How to restrict the user connections
>
>
>Senthil... You'll get a bunch of answers to this question but it seems
>to me that you have a underlying problem and you've decided to solve it
>by limiting the database to only 20 users... So, what's the underlying
>problem you're trying to solve? Is this a license issue? A technical
>issue? You'll probably get better answers that way...
>
>Tim
>
>Davey, Alan wrote:
>
>
>
>>Hi,
>>
>>Create a logon trigger that checks the number of sessions, and if more than
>>20 exists, it will randomly select one and kill it. The idea being that
>>that user has probably been on long enough and needs to learn to share
>>resources.
>>
>>Alternatively, you can set license_max_sessions in your init.ora file.
>>
>>-----------------------------------------
>>Alan Davey
>>Senior Analyst/Project Leader
>>Oracle 9i OCA; 3/4 OCP
>>w) 973.267.5990 x458
>>w) 212.295.3458
>>
>>
>>
>>-----Original Message-----
>>From: Senthil Kumar [mailto:senthilkumard_at_summitworks.com]
>>Sent: Thursday, March 18, 2004 9:28 AM
>>To: oracle-l_at_freelists.org
>>Subject: How to restrict the user connections
>>
>>
>>Hi List,
>>
>>How do I restrict the number of user connections. I want only 20 users to
>>access the database on a particular time.
>>
>>How do I do this.
>>
>>TIA
>>Senthil.
>>
>>
>>----------------------------------------------------------------
>>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>>----------------------------------------------------------------
>>To unsubscribe send email to: oracle-l-request_at_freelists.org
>>put 'unsubscribe' in the subject line.
>>--
>>Archives are at http://www.freelists.org/archives/oracle-l/
>>FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
>>-----------------------------------------------------------------
>>
>>
>>"This information in this e-mail is intended solely for the addressee and
>>may contain information which is confidential or privileged. Access to
>>
>>
>this
>
>
>>e-mail by anyone else is unauthorized. If you are not the intended
>>recipient, or believe that you have received this communication in error,
>>please do not print, copy, retransmit, disseminate, or otherwise use the
>>information. Also, please notify the sender that you have received this
>>e-mail in error, and delete the copy you received."
>>
>>
>>----------------------------------------------------------------
>>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>>----------------------------------------------------------------
>>To unsubscribe send email to: oracle-l-request_at_freelists.org
>>put 'unsubscribe' in the subject line.
>>--
>>Archives are at http://www.freelists.org/archives/oracle-l/
>>FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
>>-----------------------------------------------------------------
>>
>>
>>
>>
>
>--
>Regards,
>Tim Johnston
>Tel: 978-322-4226
>Fax: 978-322-4100
>
>
>----------------------------------------------------------------
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>----------------------------------------------------------------
>To unsubscribe send email to: oracle-l-request_at_freelists.org
>put 'unsubscribe' in the subject line.
>--
>Archives are at http://www.freelists.org/archives/oracle-l/
>FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
>-----------------------------------------------------------------
>
>----------------------------------------------------------------
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>----------------------------------------------------------------
>To unsubscribe send email to: oracle-l-request_at_freelists.org
>put 'unsubscribe' in the subject line.
>--
>Archives are at http://www.freelists.org/archives/oracle-l/
>FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
>-----------------------------------------------------------------
>
>

-- 
Regards,
Tim Johnston
Tel: 978-322-4226
Fax: 978-322-4100


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------