RE: Login Triggers
- From: Michael Milligan <Michael.Milligan@xxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 12 Mar 2004 13:15:30 -0600
BDBAFH?
-----Original Message-----
From: Maryann Atkinson [mailto:maryann_30@xxxxxxxxx]
Sent: Friday, March 12, 2004 12:07 PM
To: oracle-l@xxxxxxxxxxxxx
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
----------------------------------------------------------------
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 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@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:
