Oracle教程 2023-02-24

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

本站中文解释

Oracle视图DBA_USED_SYSPRIVS_PATH表示已经使用的系统权限的路径信息。它包括系统权限的来源（对于具有特殊系统权限的角色），也包括用户本身捆绑的系统权限。

主要包含以下列：
1.user_name：拥有该系统权限的用户；
2.granted_role：通过授予该角色而获得该系统权限的角色；
3.admin_option：指示是通过角色授予该系统权限还是用户直接拥有该系统权限；
4.granted_role：授予该系统权限的角色；
5.sys_priv：用户拥有的系统权限；
6.orig_sys_priv：最初授予该系统权限的角色/用户；
7.priv_path：该系统权限是从某种角色得到的时，指示权限从哪个角色继承而来。

使用方式：要查询某个用户拥有的系统权限，可以使用DBA_USED_SYSPRIVS_PATH视图。例如，要查询用户user1拥有的系统权限，可以执行以下查询：
select * from dba_used_sysprivs_path
where user_name = ‘user1’;

官方英文解释

DBA_USED_SYSPRIVS_PATH lists the system privileges that are 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
`SEQUENCE`	`NUMBER`	`NOT NULL`	The sequence number of the privilege analysis run during which the privilege was reported
`OS_USER`	`VARCHAR2(128)`		Operating system login username
`USERHOST`	`VARCHAR2(128)`		Client host machine name
`MODULE`	`VARCHAR2(64)`		Module name
`USERNAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the user whose privilege was reported
`USED_ROLE`	`VARCHAR2(128)`		Used role
`SYS_PRIV`	`VARCHAR2(40)`		Used system privilege
`ADMIN_OPTION`	`NUMBER`		Indicates whether the `ADMIN` option was used: `0` – Indicates that the `ADMIN` option was not used `1` – Indicates that the `ADMIN` option was used
`PATH`	`GRANT_PATH`		System privilege grant paths
`RUN_NAME`	`VARCHAR2(128)`		The name of the run during which the privilege was reported

本站中文解释

官方英文解释

相关推荐