Re: How to restrict the user connections
- From: "Juan Cachito Reyes Pacheco" <jreyes@xxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 18 Mar 2004 16:40:20 -0400
Hi Alan, this is true if he runs a single session client,
This is not true if he for example is using developer , then every window
can be a
distinct session.
Every user can have more than a session. For example what happen if he runs
an
autonomus function?
:)
----- Original Message -----
From: "Davey, Alan" <Alan.Davey@xxxxxxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Thursday, March 18, 2004 2:44 PM
Subject: 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).
>
> -----------------------------------------
> Alan Davey
> Senior Analyst/Project Leader
> Oracle 9i OCA; 3/4 OCP
> w) 973.267.5990 x458
> w) 212.295.3458
>
>
>
> -----Original Message-----
> From: Juan Cachito Reyes Pacheco [mailto:jreyes@xxxxxxxxxxxxxxxx]
> Sent: Thursday, March 18, 2004 12:00 PM
> To: oracle-l@xxxxxxxxxxxxx
> 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.
>
> ----- Original Message -----
> From: "Davey, Alan" <Alan.Davey@xxxxxxxxxxxxxxxxx>
> To: <oracle-l@xxxxxxxxxxxxx>
> Sent: Thursday, March 18, 2004 11:29 AM
> Subject: RE: How to restrict the user connections
>
>
> > 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
> > -----------------------------------------------------------------
>
>
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
>
----------------------------------------------------------------
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:
