| 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: Login Triggers
BDBAFH?
-----Original Message-----
From: Maryann Atkinson [mailto:maryann_30_at_yahoo.com]
Sent: Friday, March 12, 2004 12:07 PM
To: oracle-l_at_freelists.org
Subject: Re: Login Triggers
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
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. ---------------------------------------------------------------- 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 Fri Mar 12 2004 - 13:12:18 CST
 |
 |