Re: audit drop procedure; fails with ORA-00956

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@xxxxxxxxx> wrote:

> On Fri, Aug 21, 2009 at 7:19 AM, Ethan Post <post.ethan@xxxxxxxxx> wrote:
>
>> SQL> audit create procedure
>> Audit complete.
>> SQL> audit create any procedure
>> Audit complete.
>> SQL> audit drop any procedure
>> Audit complete.
>>
>>

Other related posts: