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
-----------------------------------------------------------------