| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: How to restrict the user connections
Hi Juan,
license_max_sessions is the correct answer until Senthil answer's Tim's question as to why it isn't good enough.
You can go the trigger route, but unless there is a compelling reason to do so (only allow specific users), it requires more time spent programming and debugging (hmm, there are 20 current users and I now I can't log in as my dba account to perform/fix xxx).
-----Original Message-----
From: Juan Cachito Reyes Pacheco [mailto:jreyes_at_dazasoftware.com]
Sent: Thursday, March 18, 2004 12:00 PM
To: oracle-l_at_freelists.org
Subject: Re: How to restrict the user connections
Hi Alan,
LICENSE_MAX_SESSIONS specifies the maximum number of concurrent user sessions allowed. When this limit is reached, only users with the RESTRICTED SESSION privilege can connect to the database. Users who are not able to connect receive a warning message indicating that the system has reached maximum capacity.
LICENSE_MAX_USERS specifies the maximum number of users you can create in the database. When you reach this limit, you cannot create more users. You can, however, increase the limit.
I think none of both are a solution, because license max user limits the number of user created, and license max sessions limits the maximum number of concurrent user sessions allowed.
I think you 'll have to use a trigger.
> 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_at_freelists.org'
> 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_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
> -----------------------------------------------------------------
>
>
> "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
> -----------------------------------------------------------------
-- 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 -----------------------------------------------------------------Received on Thu Mar 18 2004 - 14:08:53 CST
 |
 |