Re: audit drop procedure; fails with ORA-00956
- From: Jared Still <jkstill@xxxxxxxxx>
- To: Ethan Post <post.ethan@xxxxxxxxx>
- Date: Wed, 9 Sep 2009 14:59:54 -0700
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@xxxxxxxxx> 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@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:
