Oracle教程 2023-03-31

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

本站中文解释

Oracle视图DBA_UNUSED_USERPRIVS_PATH用于显示何种具有多个系统权限访问路径的用户组当前未使用的临时系统权限访问路径。此视图显示用户组、系统权限访问路径描述、未使用的临时系统权限访问路径、是否可用、是否被指定为受限制系统权限访问路径、被指定为受限制系统权限访问路径是否已启用以及相关信息。

使用此视图，您可以查询哪些用户组具有多个未使用的临时系统权限访问路径，或哪些受限制的系统权限访问路径还未启用。

官方英文解释

DBA_UNUSED_USERPRIVS_PATH lists the user 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 a 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)
`USER_PRIV`	`VARCHAR2(25)`		Unused user privilege
`ONUSER`	`VARCHAR2(128)`		The user whose user privileges the grantee can exercise
`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`		User privilege grant paths
`RUN_NAME`	`VARCHAR2(128)`		The name of the run during which the privilege was reported

本站中文解释

官方英文解释

相关推荐