Data Dictionary of Oracle 11g



Index | Home | Forums

Table Name Description
ALL_AUDIT_POLICIES All fine grained auditing policies in the database

Column ID Column name Data type Length Precision NULL Description
1OBJECT_SCHEMAVARCHAR230(null)YOwner of the table or view
2OBJECT_NAMEVARCHAR230(null)YName of the table or view
3POLICY_NAMEVARCHAR230(null)YName of the policy
4POLICY_TEXTVARCHAR24000(null)YAudit condition
5POLICY_COLUMNVARCHAR230(null)YDeprecated
6PF_SCHEMAVARCHAR230(null)YOwner of the audit handler function
7PF_PACKAGEVARCHAR230(null)YName of the package containing the audit handler function
8PF_FUNCTIONVARCHAR230(null)YName of the audit handler function
9ENABLEDVARCHAR23(null)YIs this policy is enabled?
10SELVARCHAR23(null)YIf YES, policy is applied to query on the object
11INSVARCHAR23(null)YIf YES, policy is applied to insert on the object
12UPDVARCHAR23(null)YIf YES, policy is applied to update on the object
13DELVARCHAR23(null)YIf YES, policy is applied to delete on the object
14AUDIT_TRAILVARCHAR212(null)YWhether to populate SQLTEXT and SQLBIND columns in audit trail for this policy. DB_EXTENDED -> Populate; DB -> Do not populate
15POLICY_COLUMN_OPTIONSVARCHAR211(null)YIf ALL_COLUMNS then all relevant columns apply else any of the relevant columns apply

Index | Home | Forums

This page was created by oracleabc.com on Dec 31,2007 18:49:17
General comments and questions regarding this document should be sent by email to info@oracleabc.com or post your comments here