Re: Database auditing

On 8/22/06, Jared Still <jkstill_at_gmail.com> wrote:
>
> The attached script will create a view DBA_TABLE_AUDIT_FLAGS.
>
>

The purpose of this view is just to show if any form of auditing is enabled on a table.

Should you choose to use it, the attached version will work better than the previous one that was posted. It was pointed out to me that that one was broke.

BTW, in 10g there is no need to use a WHERE clause on DBA_OBJ_AUDIT_OPTS to filter out unaudited objects, it works that way by default.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist




--
http://www.freelists.org/webpage/oracle-l




text/x-sql attachment: dba_table_audit_flags.sql