Oracle教程 2023-03-31

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

本站中文解释

：

Oracle视图DBA_UNUSED_OBJPRIVS_PATH是数据库DBA所使用的内部视图，它可以返回存储在$ORACLE_HOME/admin/OBJECTS/OBJECTS/下未使用的对象授权路径信息。此视图将存储冗余的节点、路径以及其他相关信息作为一个结果集提供给用户。此视图中的两个主要列是NODE_PATH和OBJECT_OWNER，这些列可以帮助DBA查看存储的授权信息是否正确和完整。

另外，此视图还提供了其他类似的列，如OBJECT_TYPE，USER_NAME，GRANTEE，OBJECT_NAME等，这些列可以帮助用户检查为哪些用户授予了哪些访问权限。

DBA_UNUSED_OBJPRIVS_PATH视图可以被用于查询数据库当前未使用的对象授权路径信息。它还可以被用于确认该路径是否正确，以及是否已经为该对象授予了访问权限。为了使用此视图，用户可以运行以下查询语句：

SELECT * FROM DBA_UNUSED_OBJPRIVS_PATH;

官方英文解释

DBA_UNUSED_OBJPRIVS_PATH lists the object privileges that are not used for the privilege analysis policies reported by the DBMS_PRIVILEGE_CAPTURE.GENERATE_RESULT procedure.

This view provides access to analyzed privilege records in SYS tables.

You must have the CAPTURE_ADMIN role to access this view.

Column	Datatype	NULL	Description
`CAPTURE`	`VARCHAR2(128)`	`NOT NULL`	Name of the privilege analysis policy
`USERNAME`	`VARCHAR2(128)`		Name of the user whose privileges are reported
`ROLENAME`	`VARCHAR2(128)`		Name of the role whose unused privileges are reported (for `ROLE` type privilege analysis or `ROLE AND CONTEXT` privilege analysis)
`OBJ_PRIV`	`VARCHAR2(40)`		Unused object privilege
`OBJECT_OWNER`	`VARCHAR2(128)`		Object owner
`OBJECT_NAME`	`VARCHAR2(128)`		Name of the object that `USERNAME` has `OBJ_PRIV` on
`OBJECT_TYPE`	`VARCHAR2(23)`		Type of the object that `USERNAME` has `OBJ_PRIV` on
`COLUMN_NAME`	`VARCHAR2(128)`		Name of the column that `USERNAME` has `OBJ_PRIV` on
`GRANT_OPTION`	`NUMBER`		Indicates whether the privilege is granted with the `GRANT` option: `0` – Indicates that the privilege is granted without the `GRANT` option `1` – Indicates that the privilege is granted with the `GRANT` option
`PATH`	`GRANT_PATH`		Object privilege grant paths
`RUN_NAME`	`VARCHAR2(128)`		The name of the run during which the privilege was reported

本站中文解释

官方英文解释

相关推荐