Re: audit drop procedure; fails with ORA-00956

From: Ethan Post <post.ethan_at_gmail.com>
Date: Wed, 9 Sep 2009 16:06:32 -0500
Message-ID: <357b48a90909091406v747a6562gc9d973c25d01d6c2_at_mail.gmail.com>

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:06:32 CDT

This message: [ Message body ]
Next message: Herring Dave - dherri: "RE: RAMSAN Experience"
Previous message: Mark W. Farnham: "RE: RAMSAN Experience"
In reply to: Jared Still: "Re: audit drop procedure; fails with ORA-00956"
Next in thread: Jared Still: "Re: audit drop procedure; fails with ORA-00956"
Reply: Jared Still: "Re: audit drop procedure; fails with ORA-00956"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message