Oracle教程 2023-02-24

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

本站中文解释

_VIEW

Oracle视图”DBA_USED_PUBPRIVS_VIEW”实现用户访问公有对象的权限检查，提供对对象访问权限的监视。它可以显示用户以及访问特定对象的具体类型的权限，如表、视图、索引或序列。本视图是从DBA_USED_PRIVS、SESSION_PRIVS和OBJECT_PRIVILEGES三个视图之间检索信息，因此允许检查已使用的特定实例权限以及特定用户/对象的权限。

使用方法:

要使用”DBA_USED_PUBPRIVS_VIEW”视图，首先要查找当前活动会话中用户拥有的公有访问控件，可以运行以下SQL查询：

SELECT GRANTEE, PRIVILEGE FROM DBA_USED_PUBPRIVS_VIEW;

这将显示所有授予的公共权限，比如SELECT、INSERT、UPDATE和DELETE。要查询特定用户拥有某种公共权限，可以更改查询条件：

SELECT GRANTEE, PRIVILEGE FROM DBA_USED_PUBPRIVS_VIEW WHERE GRANTEE=‘username’

这将显示给特定用户的公共权限。

官方英文解释

DBA_USED_PUBPRIVS lists the privileges that are used from the PUBLIC role 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 who used the privilege from the `PUBLIC` role
`SYS_PRIV`	`VARCHAR2(40)`		Used system privilege
`OBJ_PRIV`	`VARCHAR2(40)`		Used object privilege
`OBJECT_OWNER`	`VARCHAR2(128)`		Object owner
`OBJECT_NAME`	`VARCHAR2(128)`		Name of the object that `OBJ_PRIV` is used to access
`OBJECT_TYPE`	`VARCHAR2(23)`		Type of the object that `OBJ_PRIV` is used to access
`OPTION$`	`NUMBER`		Indicates whether the `GRANT` option or the `ADMIN` option was used: `0` – Indicates that the `GRANT` option or `ADMIN` option was not used `1` – Indicates that the `GRANT` option or `ADMIN` option was used
`RUN_NAME`	`VARCHAR2(128)`		The name of the run during which the privilege was reported

本站中文解释

官方英文解释

相关推荐