Oracle教程 2023-02-23

Oracle 视图 ALL_POLICIES 官方解释，作用，如何使用详细说明

本站中文解释

【Oracle视图 ALL_POLICIES】

ALL_POLICIES 视图包含Oracle数据库中已创建的全部策略。该视图的列摘要如下：

– POLICY_NAME：策略的名称。
– OWNER：策略的拥有者。
– POLICY_GROUP_NAME：策略组的名称。
– POLICY_FUNCTION：绑定到策略的函数或存储过程。

【用途及使用】

ALL_POLICIES 视图主要用于查询策略信息。例如，可以使用该视图查询指定拥有者的策略信息：

SELECT * FROM all_policies WHERE owner = ‘SCHEMA’;

官方英文解释

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	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.
`COMMON`	`VARCHAR2(3)`	Indicates whether the policy is applied and enforced in all application PDBs (`YES`) or only in the local PDB (`NO`)
`INHERITED`	`VARCHAR2(3)`	Indicates whether the policy is inherited from the root (`YES`) or not (`NO`)

本站中文解释

官方英文解释

相关推荐