Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

auditing problem

Roger25Jul 6 2011 — edited Jul 6 2011
Hi,
First of all, i've read in documentation that:

DROP ANY PROCEDURE Allows execution of DROP FUNCTION, DROP PACKAGE & DROP PROCEDURE commands in any schema.

Ok, i have: audit drop any procedure by roger by access;
i connect with roger, i create a FUNCTION, then i drop it. But in dba_audit_object i see only the create function action, the DROP function isn't audited. I want to know why..

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 3 2011
Added on Jul 6 2011
10 comments
362 views