From oracle-l-bounce@freelists.org Fri Mar 12 13:05:53 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2CJ5rL02970 for ; Fri, 12 Mar 2004 13:05:53 -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 i2CJ5qo02965 for ; Fri, 12 Mar 2004 13:05:53 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 36A00395B42; Fri, 12 Mar 2004 14:05:09 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 12 Mar 2004 14:03:53 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from amer-mta01.csc.com (amer-mta01.csc.com [20.137.2.247]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 70938395AB0 for ; Fri, 12 Mar 2004 14:03:50 -0500 (EST) Received: from csc.com (va-fch34.csc.com [20.6.39.227]) by amer-mta01.csc.com (Switch-3.1.2/Switch-3.1.0) with ESMTP id i2CJBoZB024307 for ; Fri, 12 Mar 2004 14:11:50 -0500 (EST) Received: from computer-qd3rtm.yahoo.com ([20.4.114.43]) by csc.com (Lotus Domino Release 6.0.3) with ESMTP id 2004031214104335-10835 ; Fri, 12 Mar 2004 14:10:43 -0500 Message-Id: <5.2.1.1.2.20040312140345.01aac108@pop.netaddress.com> X-Sender: (Unverified) X-Mailer: QUALCOMM Windows Eudora Version 5.2.1 Date: Fri, 12 Mar 2004 14:07:25 -0500 To: oracle-l@freelists.org From: Maryann Atkinson Subject: Re: Login Triggers In-Reply-To: <20040312184348.GA2563@mladen.wangtrading.com> References: <5.2.1.1.2.20040312123638.01a90138@pop.netaddress.com> <5.2.1.1.2.20040312112644.00bc8028@pop.netaddress.com> <4051DF65.5D9D9E@sun.com> <5.2.1.1.2.20040312104106.01ceac38@pop.netaddress.com> <4051DF65.5D9D9E@sun.com> <5.2.1.1.2.20040312112644.00bc8028@pop.netaddress.com> <5.2.1.1.2.20040312123638.01a90138@pop.netaddress.com> Mime-Version: 1.0 X-MIMETrack: Itemize by SMTP Server on VA-FCH34/SRV/CSC(Release 6.0.3|September 26, 2003) at 03/12/2004 02:10:43 PM, Serialize by Router on VA-FCH34/SRV/CSC(Release 6.0.3|September 26, 2003) at 03/12/2004 02:10:44 PM, Serialize complete at 03/12/2004 02:10:44 PM Content-Type: text/plain; charset="us-ascii"; format=flowed X-archive-position: 725 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: maryann_30@yahoo.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l At 01:43 PM 3/12/2004, you wrote: > > I'm confused. The original question was asked by the person named Maryann, > > so I'm not sure about the "we" part. Its ok, I've been confused for 30 some years... I meant "we" as in us here in my department... > If your intention is to pre-run query and store results in memory, > then yes, that would be the best solution, in my opinion. yes, thats why I too thought login triggers might have an advantage... > > Login trigger is a procedure and not a mechanism for storing things. If > you > > want to check something and deny login based on some additional > criteria or > > turn on things like event 10046 for some classes of users, then yes, login > > trigger would have an advantage. Yes, but we could upon login issue a query, and store the results into some global memory variables, right? > Now you gave me an idea. Being a BDBAFH, I'll implement it sooner or later. Huh? thanks again maa ---------------------------------------------------------------- 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 -----------------------------------------------------------------