Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Warn on login failure

Re: Warn on login failure

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 03 Feb 2006 09:17:37 -0800
Message-ID: <1138987054.103696@jetspin.drizzle.com>


EdStevens wrote:
> DA Morgan wrote:
>

>>felipe.rivabem_at_gmail.com wrote:
>>
>>>i donīt think itīs a good idea to create a trigger on sys.aud$, and i
>>>donīt even know if itīs a real table :P
>>
>>It is bad advice for a number of reasons and given the version of Oracle
>>auditing SYS may be pretty much a joke anyway.
>>
>>So lets start with basics ... what version of Oracle?
>>--
>>Daniel A. Morgan
>>http://www.psoug.org
>>damorgan_at_x.washington.edu
>>(replace x with u to respond)

>
>
> Daniel,
>
> Could you expand on why it's bad advice? I'm not trying to be
> combative ... I was just shooting from the hip, tossing out some
> possible ideas, and really don't mind being shot down if I can learn
> something from the experience.
>
> - Ed Stevens

Because that trigger is going to fire every single time an insert takes place. Every time ... whether appropriate or not. In addition you are placing a trigger on an object owned by SYS which is always a bad idea. And for most Oracle versions you can not audit SYS.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Fri Feb 03 2006 - 11:17:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US