Oracle教程 2023-02-24

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

本站中文解释

Oracle视图：DBA_USED_OBJPRIVS_PATH

用途：这个视图是在下面的情况下使用的：当用户使用现有的对象权限访问一个对象(例如，一个表)时，它可用于检查这个路径以及这个对象权限如何被继承。

使用方法：使用DBA_USED_OBJPRIVS_PATH视图可以查看某个用户获得权限的路径，以及以及有哪些用户可以访问哪些对象的层次架构。它将包括这样的数据：用户名、授予的权限、提供此权限的对象、位置以及几种可能的访问方法(继承或者显式授权)。

官方英文解释

DBA_USED_OBJPRIVS_PATH lists the object 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 the 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
`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
`COLUMN_NAME`	`VARCHAR2(128)`		Name of the column that `OBJ_PRIV` is used to access
`GRANT_OPTION`	`NUMBER`		Indicates whether the `GRANT` option was used: `0` – Indicates that the `GRANT` option was not used `1` – Indicates that the `GRANT` option was used
`PATH`	`GRANT_PATH`		Object privilege grant paths
`RUN_NAME`	`VARCHAR2(128)`		The name of the run during which the privilege was reported

本站中文解释

官方英文解释

相关推荐