eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.DBA_AUDIT_POLICIES

Object Details

Object Name:	DBA_AUDIT_POLICIES
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Fine grained auditing policies in the database

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
OBJECT_SCHEMA	VARCHAR2	(128)	Yes	Owner of the table or view
OBJECT_NAME	VARCHAR2	(128)	Yes	Name of the table or view
POLICY_OWNER	VARCHAR2	(128)	Yes	Owner of the policy
POLICY_NAME	VARCHAR2	(128)	Yes	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

Query Text

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.DBA_AUDIT_POLICIES;

Dependencies

[top of page]

SYS.DBA_AUDIT_POLICIES references the following:

SYS: FGA$; OBJ$; USER$

SYS.DBA_AUDIT_POLICIES is referenced by following:

PUBLIC: DBA_AUDIT_POLICIES
SYS: ALL_AUDIT_POLICIES; DBMS_FEATURE_FGA_AUDIT - show dependent code; USER_AUDIT_POLICIES