1. Database Reference
  2. Static Data Dictionary Views
  3. Static Data Dictionary Views: ALL_PART_COL_STATISTICS to DATABASE_PROPERTIES
  4. ALL_POLICY_GROUPS

3.16 ALL_POLICY_GROUPS

ALL_POLICY_GROUPS describes the policy groups defined for the synonyms, tables, and views accessible to the current user.

Related Views

  • DBA_POLICY_GROUPS describes all policy groups in the database.

  • USER_POLICY_GROUPS describes the policy groups defined for the synonyms, tables, and views 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

COMMON

VARCHAR2(3)

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

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

INHERITED

VARCHAR2(3)

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

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

See Also: