DBA FUS‎ > ‎

Audit Table Ownership and Audit Table Permissions

posted Sep 13, 2010, 6:28 AM by Sachchida Ojha
select owner from dba_tables where table_name='AUD$';
select count(*) from ALL_DEF_AUDIT_OPTS where ren='A/A';
select grantee from dba_tab_privs
       where table_name='AUD$'
        and grantee not in ('DELETE_CATALOG_ROLE')
        and grantee not in
         (select grantee from dba_role_privs where granted_role='DBA')
        order by grantee;