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!

how to audit all grants and revoke statements?

733414Jun 22 2010 — edited Jun 24 2010
I tried the following and checked dba_audit_trail, but it does not seem to work. I need to audit every time someone issues a grant and a revoke statement.


audit grant any object privilege by access;
audit grant any privilege by access;
audit grant any role by access;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 22 2010
Added on Jun 22 2010
5 comments
8,240 views