Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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 EvangelistReceived on Tue Aug 22 2006 - 17:22:57 CDT-- http://www.freelists.org/webpage/oracle-l
- text/x-sql attachment: dba_table_audit_flags.sql
![]() |
![]() |