From oracle-l-bounce@freelists.org Thu Mar 18 15:24:52 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2ILOo426331 for ; Thu, 18 Mar 2004 15:24:50 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i2ILOjo26316 for ; Thu, 18 Mar 2004 15:24:46 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5BB2C390D09; Thu, 18 Mar 2004 15:55:32 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 18 Mar 2004 15:54:27 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from mail.acelerate.com (mail.acelerate.com [200.105.128.132]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id D5B0339582E for ; Thu, 18 Mar 2004 15:46:29 -0500 (EST) Received: (qmail 30257 invoked from network); 18 Mar 2004 20:43:39 -0000 Received: from dazasoftware.com (HELO org48l7d9ara8b) (200.105.151.94) by 0 with SMTP; 18 Mar 2004 20:43:39 -0000 Message-ID: <001701c40d2a$83a4f530$2501a8c0@dazasoftware.com> From: "Juan Cachito Reyes Pacheco" To: References: <7487761A46884449834CAD636919C07B0120CDB9@nycexc02.Denver.cjds.com> Subject: Re: How to restrict the user connections Date: Thu, 18 Mar 2004 16:40:20 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="Windows-1252" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-archive-position: 1182 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jreyes@dazasoftware.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l 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" To: 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@dazasoftware.com] > Sent: Thursday, March 18, 2004 12:00 PM > To: oracle-l@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. > > ----- Original Message ----- > From: "Davey, Alan" > To: > 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@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@summitworks.com] > > Sent: Thursday, March 18, 2004 9:28 AM > > To: oracle-l@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@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@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@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@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@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@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 -----------------------------------------------------------------