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 theOBJECT_OWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the synonym, table, or view |
|
|
|
Name of the synonym, table, or view |
|
|
|
Name of the policy group |
|
|
|
Name of the policy |
|
|
|
Owner of the policy function |
|
|
|
Name of the package containing the policy function |
|
|
|
Name of the policy function |
|
|
|
Indicates whether the policy is applied to queries on the object ( |
|
|
|
Indicates whether the policy is applied to |
|
|
|
Indicates whether the policy is applied to |
|
|
|
Indicates whether the policy is applied to |
|
|
|
Indicates whether the policy is enforced for index maintenance on the object ( |
|
|
|
Indicates whether the check option is enforced for the policy ( |
|
|
|
Indicates whether the policy is enabled ( |
|
|
|
Indicates whether the policy is static ( |
|
|
|
Policy type:
|
|
|
|
Indicates whether the policy function can return a maximum of 32 KB of predicate ( |
|
|
|
Indicates whether the policy is applied and enforced in all application PDBs ( |
|
|
|
Indicates whether the policy is inherited from the root ( |
See Also:
-
Oracle Database Concepts for an overview of security policies and fine-grained access control
-
Oracle Database Security Guide for more information about security policies
-
The
DBMS_RLS
package in Oracle Database PL/SQL Packages and Types Reference for information on administering security policies