Table: DBA_AUDIT_POLICIES
All fine grained auditing policies in the database
| Column Name | Description |
|---|---|
| ENABLED | Is this policy is enabled? |
| OBJECT_NAME | Name of the table or view |
| OBJECT_SCHEMA | Owner of the table or view |
| PF_FUNCTION | Name of the audit handler function |
| PF_PACKAGE | Name of the package containing the audit handler function |
| PF_SCHEMA | Owner of the audit handler function |
| POLICY_COLUMN | Relevant column |
| POLICY_NAME | Name of the policy |
| POLICY_TEXT | Audit condition |