Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Warn on login failure
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)
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