Re: auditing package alterations

"Marcin" <marrgo72Rem0ve_at_gazeta.pl> a écrit dans le message de news:opr4ynh3gm5uw272_at_news.icm.edu.pl...
> Hello!
>
> I've got a question to specialists :-)
>
> How to audit all package/procedure/function alterations, such as package
> recompilations?
>
> What would be the audit statement for this?
>
> Thanks in advance,
> Marcin

Why would you want to do that ? Not trusting the developpers ? Have them use some source control tool, or implement good coding practices (Let them do some backup before replacing procedures/packages)

You could use oracle auditing (You have to set it up in your instance, also look at the oracle AUDIT statement in sql and administration reference)

If you have metalink, May I suggest the Document #167293.1 and #1020945.6

Unless you really need it, managing auditing is more trouble than it's worth, IMHO. Also note that if you audit in the DB, you'll need some space from the SYSTEM tablespace to keep the audit records.

Also, bear in mind that (At least on 8i) you cannot audit at the object level for a particular user only. It's system wide or nothing. Received on Tue Mar 16 2004 - 13:17:46 CST