Re: audit drop procedure; fails with ORA-00956

From: Jared Still <jkstill_at_gmail.com>
Date: Wed, 9 Sep 2009 08:54:52 -0700
Message-ID: <bf46380909090854i3925f947vdd48e06545c2bee2_at_mail.gmail.com>

On Fri, Aug 21, 2009 at 7:19 AM, Ethan Post <post.ethan_at_gmail.com> wrote:

> SQL> audit create procedure
> Audit complete.
> SQL> audit create any procedure
> Audit complete.
> SQL> audit drop any procedure
> Audit complete.
>
> -- Why does this fail? Isn't this just the opposite of CREATE PROCEDURE. It
> is listed in the exact same section of the docs as CREATE PROCEDURE, I would
> think the syntax is the same.
>
>

Interesting.

One would think that 'AUDIT CREATE PROCEDURE' would cause any drop procedure actions to appear in the audit log, as the DROP PROCEDURE privilege is applied
( or maybe just part of) the CREATE PROCEDURE privilege.

Just now I tried a small test, and while creating a procedure does cause an entry
in sys.aud$, dropping a procedure does not.

Curios.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 09 2009 - 10:54:52 CDT