From oracle-l-bounce@freelists.org Mon Feb 14 07:53:52 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j1EDrqGZ005947 for ; Mon, 14 Feb 2005 07:53:52 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j1EDrqem005943 for ; Mon, 14 Feb 2005 07:53:52 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 270B0713D2; Mon, 14 Feb 2005 07:52:43 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 15269-01; Mon, 14 Feb 2005 07:52:43 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9F19E7138E; Mon, 14 Feb 2005 07:52:42 -0500 (EST) Message-ID: <06f201c5129b$64b76aa0$e300a8c0@user12344> From: "Yechiel Adar" To: References: Subject: Re: How to limt user connections Date: Mon, 14 Feb 2005 15:44:59 +0200 MIME-Version: 1.0 Content-type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700 X-archive-position: 16123 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: adar76@inter.net.il Precedence: normal Reply-To: adar76@inter.net.il X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=1.0 required=5.0 tests=AWL,FROM_ENDS_IN_NUMS autolearn=no version=2.60 X-Spam-Level: Logon trigger by itself will not work if the user connects before the deadline. You also need to run a script to kill all sessions of the users after the cutoff time. Yechiel Adar Mehish Computer Services ----- Original Message ----- From: "David Sharples" To: Sent: Sunday, February 06, 2005 5:00 PM Subject: Re: How to limt user connections > logon trigger based on username > > > On Sun, 6 Feb 2005 15:55:39 +0100, Sonja =C5=A0ehovi=C4=87 bz.hr>=20 > > Oracle 9.2.4 in AIX 5.2. > > I would like to limit time frame when some of my users can connect to =3D > > one of the databases.=3D20 > > That is, they can do whathever they want/need between 6 p.m. and 7. =3D > > a.m...:-) > > Is that possible to do with profiles? Or is there any other (better) =3D > > method? > -- > http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l