RE: How to restrict the user connections
- From: "Davey, Alan" <Alan.Davey@xxxxxxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 18 Mar 2004 08:29:10 -0700
Hi,
I replied to your email too quickly.
You can also set license_max_sessions dynamically via alter system. So if
you only need to set it for certain times, then that is another option.
HTH,
-----------------------------------------
Alan Davey
Senior Analyst/Project Leader
Oracle 9i OCA; 3/4 OCP
w) 973.267.5990 x458
w) 212.295.3458
-----Original Message-----
From: Davey, Alan
Sent: Thursday, March 18, 2004 9:40 AM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: How to restrict the user connections
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@xxxxxxxxxxxxxxx]
Sent: Thursday, March 18, 2004 9:28 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts: