Oracle教程 2023-02-24

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

本站中文解释

Oracle视图DBA_UNUSED_SYSPRIVS_PATH是描述用户未使用的系统特权路径的数据字典视图。

1. 信息的说明：
（1）GRANTEE_NAME：授予系统特权的用户或角色的名称；
（2）GRANTEE_TYPE：授予系统特权的用户或角色的类型，可以取值ROLE或USER；
（3）SYSPRIV_NAME：当前授予的系统特权的名称；
（4）PRIV_TYPE：当前授予的系统特权的类型，可以取值AUDIT_SYSTEM、CREATE_ANY_RESTYRLE等；
（5）PATH：授予系统特权路径；
（6）ACTIVE_FLAG：活动标记，说明是否被活动使用，可以取1或0，1表示被活动使用，0表示未被活动使用；

2. 如何使用：
当你想要查看一个特定类型的用户或角色未被激活使用的特权时，你可以使用DBA_UNUSED_SYSPRIVS_PATH视图：
SELECT GRANTEE_NAME,GRANTEE_TYPE,SYSPRIV_NAME,PRIV_TYPE,PATH,ACTIVE_FLAG
FROM DBA_UNUSED_SYSPRIVS_PATH
WHERE GRANTEE_TYPE=’USER’ AND ACTIVE_FLAG=’0’;

官方英文解释

DBA_UNUSED_SYSPRIVS_PATH lists the system 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)
`SYS_PRIV`	`VARCHAR2(40)`		Unused system privilege
`ADMIN_OPTION`	`NUMBER`		Indicates whether the privilege is granted with the `ADMIN` option: `0` – Indicates that the privilege is granted without the `ADMIN` option `1` – Indicates that the privilege is granted with the `ADMIN` option
`PATH`	`GRANT_PATH`		System privilege grant paths
`RUN_NAME`	`VARCHAR2(128)`		The name of the run during which the privilege was reported

本站中文解释

官方英文解释

相关推荐