How do you Auditing of Schema Objects
Posted on 2006-04-21
I have this description of what objec auditing is. However, I still don't understand how it should be implemented or what I should change. Here is a description:
Description: Object auditing data can be reviewed in the Audit Configuration report. Object level auditing can be enabled for Oracle objects such as tables, views, stored procedures, functions, and packages. One or more operations for each object can be audited for all users or specific users. In addition, you may choose to generate one record for each access to an object (BY ACCESS) or to create one audit record per session (BY SESSION). Schema object auditing required by DISA is limited to RENAME on custom application objects and UPDATE and DELETE operations on the audit data table if applicable.
Manual Check: From SQL*Plus:
select count(*) from ALL_DEF_AUDIT_OPTS where ren='A/A';
I ran the manual check and it returned no rows. Is this ren field suppose to be populated? What does it mean? Will populating it break anything? Could someone who understands this please help me? I need to resolve this today. Thanks!