Re: audit drop procedure; fails with ORA-00956

From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 10 Sep 2009 08:55:19 -0700
Message-ID: <bf46380909100855j29dce170w1e233f54f46abfc0_at_mail.gmail.com>

Awesome, thanks Don.
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

On Thu, Sep 10, 2009 at 8:41 AM, Don Granaman <DonGranaman_at_solutionary.com>wrote:

> ‘audit procedure’ will audit drop, create, alter and more.
> ------------------------------
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Jared Still
> *Sent:* Wednesday, September 09, 2009 5:00 PM
> *To:* Ethan Post
> *Cc:* oracle-l
> *Subject:* Re: audit drop procedure; fails with ORA-00956
>
>
>
> 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 Thu Sep 10 2009 - 10:55:19 CDT