Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E17110-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

ALL_POLICIES

ALL_POLICIES describes all Oracle Virtual Private Database (VPD) security policies for objects accessible to the current user. A security policy is a list of security requirements and rules that regulate access to those database objects.

Related Views

Column Datatype NULL Description
OBJECT_OWNER VARCHAR2(30) NOT NULL Owner of the synonym, table, or view
OBJECT_NAME VARCHAR2(30) NOT NULL Name of the synonym, table, or view
POLICY_GROUP VARCHAR2(30) NOT NULL Name of the policy group
POLICY_NAME VARCHAR2(30) NOT NULL Name of the policy
PF_OWNER VARCHAR2(30) NOT NULL Owner of the policy function
PACKAGE VARCHAR2(30)   Name of the package containing the policy function
FUNCTION VARCHAR2(30) NOT NULL Name of the policy function
SEL VARCHAR2(3)   Indicates whether the policy is applied to queries on the object (YES) or not (NO)
INS VARCHAR2(3)   Indicates whether the policy is applied to INSERT statements on the object (YES) or not (NO)
UPD VARCHAR2(3)   Indicates whether the policy is applied to UPDATE statements on the object (YES) or not (NO)
DEL VARCHAR2(3)   Indicates whether the policy is applied to DELETE statements on the object (YES) or not (NO)
IDX VARCHAR2(3)   Indicates whether the policy is enforced for index maintenance on the object (YES) or not (NO)
CHK_OPTION VARCHAR2(3)   Indicates whether the check option is enforced for the policy (YES) or not (NO)
ENABLE VARCHAR2(3)   Indicates whether the policy is enabled (YES) or disabled (NO)
STATIC_POLICY VARCHAR2(3)   Indicates whether the policy is static (YES) or not (NO)
POLICY_TYPE VARCHAR2(24)   Policy type:
  • STATIC

  • SHARED_STATIC

  • CONTEXT_SENSITIVE

  • SHARED_CONTEXT_SENSITIVE

  • DYNAMIC

LONG_PREDICATE VARCHAR2(3)   Indicates whether the policy function can return a maximum of 32 KB of predicate (YES) or not (NO). If NO, the default maximum predicate size is 4000 bytes.

See Also: