Oracle教程 2023-02-24

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

本站中文解释

Oracle 视图 DBA_USED_USERPRIVS 提供了当前用户所使用过的所有用户特权的详细信息。它显示了授予用户修改权限的对象，以及启用特定特权时间等。

使用 DBA_USED_USERPRIVS 视图可以帮助 DBA 更好地了解一个用户授予了哪些权限，使用时的情况及风险。下面的查询可以显示某个用户授予的所有特权:

SELECT * FROM DBA_USED_USERPRIVS WHERE GRANTEE = ‘username’;

官方英文解释

DBA_USED_USERPRIVS lists the user privileges (without privilege grant paths) 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
`USER_PRIV`	`VARCHAR2(25)`		Used 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
`RUN_NAME`	`VARCHAR2(128)`		The name of the run during which the privilege was reported

本站中文解释

官方英文解释

相关推荐