Re: audit drop procedure; fails with ORA-00956

From: Jared Still <jkstill_at_gmail.com>
Date: Wed, 9 Sep 2009 14:59:54 -0700
Message-ID: <bf46380909091459o53e99f88kb3e67f0aecc34628_at_mail.gmail.com>



Guess I wasn't too clear on that last post. No, there isn't a drop procedure privilege, the privileges to drop objects are implicit with the granting of the privilege to create said object.

It would be nice if they were audited however.

Enhancement request?

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

On Wed, Sep 9, 2009 at 2:06 PM, Ethan Post <post.ethan_at_gmail.com> wrote:

> Someone contacted me offline.
>
> "SYSTEM_PRIVILEGE_MAP lists available system privileges within the system,
> and DROP PROCEDURE is not a valid privilege, so therefore you cannot audit
> drop procedure."
>
> The docs must be wrong.
>
>
> On Wed, Sep 9, 2009 at 10:54 AM, Jared Still <jkstill_at_gmail.com> wrote:
>
>> 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.
>>>
>>>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 09 2009 - 16:59:54 CDT

Original text of this message