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

VIEW: SYS.ALL_POLICIES

Object Details
Object Name: ALL_POLICIES
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

All policies for objects if the user has system privileges or owns the objects

[View Source]

Columns
Name Datatype Length Mandatory Comments
OBJECT_OWNER VARCHAR2 (128)
Owner of the synonym, table, or view
OBJECT_NAME VARCHAR2 (128)
Name of the synonym, table, or view
POLICY_GROUP VARCHAR2 (128)
POLICY_NAME VARCHAR2 (128)
Name of the policy
PF_OWNER VARCHAR2 (128)
Owner of the policy function
PACKAGE VARCHAR2 (128)
Name of the package containing the policy function
FUNCTION VARCHAR2 (128)
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.ALL_POLICIES;

Dependencies

[top of page]

SYS.ALL_POLICIES references the following:

SchemaSYS
ViewALL_SYNONYMS
ViewALL_TABLES
ViewALL_VIEWS
ViewDBA_POLICIES
FunctionGETLONG
SYS.ALL_POLICIES is referenced by following:

SchemaPUBLIC
SynonymALL_POLICIES