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.USER_AUDIT_POLICIES

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
OBJECT_NAME	VARCHAR2	(128)	Yes
POLICY_OWNER	VARCHAR2	(128)	Yes
POLICY_NAME	VARCHAR2	(128)	Yes
POLICY_TEXT	VARCHAR2	(4000)
POLICY_COLUMN	VARCHAR2	(128)
PF_SCHEMA	VARCHAR2	(128)
PF_PACKAGE	VARCHAR2	(128)
PF_FUNCTION	VARCHAR2	(128)
ENABLED	VARCHAR2	(3)
SEL	VARCHAR2	(3)
INS	VARCHAR2	(3)
UPD	VARCHAR2	(3)
DEL	VARCHAR2	(3)
AUDIT_TRAIL	VARCHAR2	(12)
POLICY_COLUMN_OPTIONS	VARCHAR2	(11)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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.USER_AUDIT_POLICIES;

Dependencies

[top of page]

SYS.USER_AUDIT_POLICIES references the following:

SYS: DBA_AUDIT_POLICIES

SYS.USER_AUDIT_POLICIES is referenced by following:

PUBLIC: USER_AUDIT_POLICIES