Oracle教程 2023-02-24

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

V$VPD_POLICY视图用来查看基于安全策略的私有数据库(VPD)政策的信息。它显示了每个VPD策略的定义，相关的安全级别，添加的任何查询条件以及查询中执行的操作。

如何使用:

使用V$VPD_POLICY视图，可以查看Oracle私有数据库(VPD)安全策略的定义。该视图将为对象分配的相应VPD策略显示信息，包括安全级别、查询条件和操作等。

例如，要查询VPD策略名称为“VPD_EMP_POL”的定义，请使用以下查询：

SELECT * FROM V$VPD_POLICY WHERE POLICY_NAME = ‘VPD_EMP_POL’;

V$VPD_POLICY displays all the fine-grained security policies and predicates associated with the cursors currently in the library cache.

Column	Datatype	Description
`ADDRESS`	`RAW(4 \| 8)`	Cursor address
`PARADDR`	`RAW(4 \| 8)`	Parent cursor address
`SQL_HASH`	`NUMBER`	SQL hash number
`SQL_ID`	`VARCHAR2(13)`	SQL identifier
`CHILD_NUMBER`	`NUMBER`	Cursor’s child number under the parent
`OBJECT_OWNER`	`VARCHAR2(128)`	Owner of the object with the policy
`OBJECT_NAME`	`VARCHAR2(128)`	Name of the object with the policy
`POLICY_GROUP`	`VARCHAR2(128)`	Name of the policy group
`POLICY`	`VARCHAR2(128)`	Name of the policy
`POLICY_FUNCTION_OWNER`	`VARCHAR2(128)`	Owner of the policy function
`PREDICATE`	`VARCHAR2(4000)`	Predicate for the policy (truncated to `4000` bytes in length)
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data

分享到：