[Home] [Help] [Dependency Information]
Object Name: | ALL_AUDIT_POLICIES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
All fine grained auditing policies in the database
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OBJECT_SCHEMA | VARCHAR2 | (128) | Owner of the table or view | |
OBJECT_NAME | VARCHAR2 | (128) | Name of the table or view | |
POLICY_OWNER | VARCHAR2 | (128) | Owner of the policy | |
POLICY_NAME | VARCHAR2 | (128) | Name of the policy | |
POLICY_TEXT | VARCHAR2 | (4000) | Audit condition | |
POLICY_COLUMN | VARCHAR2 | (128) | Deprecated | |
PF_SCHEMA | VARCHAR2 | (128) | Owner of the audit handler function | |
PF_PACKAGE | VARCHAR2 | (128) | Name of the package containing the audit handler function | |
PF_FUNCTION | VARCHAR2 | (128) | Name of the audit handler function | |
ENABLED | VARCHAR2 | (3) | Is this policy is enabled? | |
SEL | VARCHAR2 | (3) | If YES, policy is applied to query on the object | |
INS | VARCHAR2 | (3) | If YES, policy is applied to insert on the object | |
UPD | VARCHAR2 | (3) | If YES, policy is applied to update on the object | |
DEL | VARCHAR2 | (3) | If YES, policy is applied to delete on the object | |
AUDIT_TRAIL | VARCHAR2 | (12) | Whether to populate SQLTEXT and SQLBIND columns in audit trail for this policy. DB_EXTENDED -> Populate; DB -> Do not populate | |
POLICY_COLUMN_OPTIONS | VARCHAR2 | (11) | If ALL_COLUMNS then all relevant columns apply else any of the relevant columns apply |
Cut, paste (and edit) the following text to query this object:
SELECT OBJECT_SCHEMA
, OBJECT_NAME
, POLICY_OWNER
, POLICY_NAME
, POLICY_TEXT
, POLICY_COLUMN
, PF_SCHEMA
, PF_PACKAGE
, PF_FUNCTION
, ENABLED
, SEL
, INS
, UPD
, DEL
, AUDIT_TRAIL
, POLICY_COLUMN_OPTIONS
FROM SYS.ALL_AUDIT_POLICIES;
|
|
|