3.13 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 row level access to those database objects.

Related Views

  • DBA_POLICIES describes all Oracle Virtual Private Database (VPD) security policies in the database.

  • USER_POLICIES describes all Oracle Virtual Private Database (VPD) security policies associated with objects owned by the current user. This view does not display the OBJECT_OWNER column.

Column Datatype NULL Description

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)

Name of the policy group

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)

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). This column is obsolete because information about static policies is shown in the POLICY_TYPE column.

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.

COMMONFoot 1

VARCHAR2(3)

Indicates whether the policy is applied and enforced in all application PDBs (YES) or only in the local PDB (NO)

INHERITEDFootref 1

VARCHAR2(3)

Indicates whether the policy is inherited from the root (YES) or not (NO)

Footnote 1

This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).

See Also: