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_POLICIES

Object Details

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

All row level security policies in the database

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
OBJECT_OWNER	VARCHAR2	(128)	Yes	Owner of the synonym, table, or view
OBJECT_NAME	VARCHAR2	(128)	Yes	Name of the synonym, table, or view
POLICY_GROUP	VARCHAR2	(128)	Yes	Name of the policy group
POLICY_NAME	VARCHAR2	(128)	Yes	Name of the policy
PF_OWNER	VARCHAR2	(128)	Yes	Owner of the policy function
PACKAGE	VARCHAR2	(128)		Name of the package containing the policy function
FUNCTION	VARCHAR2	(128)	Yes	Name of the policy function
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
IDX	VARCHAR2	(3)		If YES, policy is applied to IDX on the object
CHK_OPTION	VARCHAR2	(3)		Is check option enforced for this policy?
ENABLE	VARCHAR2	(3)		Is this policy is enabled?
STATIC_POLICY	VARCHAR2	(3)		Is this policy is static?
POLICY_TYPE	VARCHAR2	(24)		policy types
LONG_PREDICATE	VARCHAR2	(3)		If YES, maximum predicate size can be 32K

Query Text

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


SELECT OBJECT_OWNER
,      OBJECT_NAME
,      POLICY_GROUP
,      POLICY_NAME
,      PF_OWNER
,      PACKAGE
,      FUNCTION
,      SEL
,      INS
,      UPD
,      DEL
,      IDX
,      CHK_OPTION
,      ENABLE
,      STATIC_POLICY
,      POLICY_TYPE
,      LONG_PREDICATE
FROM SYS.DBA_POLICIES;

Dependencies

[top of page]

SYS.DBA_POLICIES references the following:

SYS: RLS$; USER$; _CURRENT_EDITION_OBJ

SYS.DBA_POLICIES is referenced by following:

APPS: AMS_LIST_RUNNING_TOTAL_PVT - show dependent code; FND_ACCESS_CONTROL_UTIL - show dependent code; HZ_ELOCATION_PKG - show dependent code
PUBLIC: DBA_POLICIES
SYS: ALL_POLICIES; GET_TABLE_NAME; IS_VPD_ENABLED; USER_POLICIES