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

VIEW: SYS.USER_POLICIES

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

All row level security policies for synonyms, tables, or views owned by the user

[View Source]

Columns
Name Datatype Length Mandatory Comments
OBJECT_NAME VARCHAR2 (128) Yes Name of the synonym, table, or view
POLICY_GROUP VARCHAR2 (128) Yes
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 is 32K
Query Text

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


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

Dependencies

[top of page]

SYS.USER_POLICIES references the following:

SchemaSYS
ViewDBA_POLICIES
SYS.USER_POLICIES is referenced by following:

SchemaPUBLIC
SynonymUSER_POLICIES