Oracle教程 2023-02-23

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

ALL_TAB_PRIVS_MADE 是 Oracle 视图。它从标准表（all_tab_privs）中提取出授权给用户的权限，只显示从用户到表的授权。

ALL_TAB_PRIVS_MADE 视图所显示的内容与用户授权管理有关，可以用来检查用户对特定表的权限。它包括了以下内容：

GRANTEE：即拥有权限的用户；

TABLE_NAME：被授权的表名；

PRIVILEGE：权限的类型，如SELECT or INSERT；

GRANTABLE：授权（GRANT）是否可传播给其他用户；

HIERARCHY：授予了何种层次的权限，如系统级、对象级等。

要使用 ALL_TAB_PRIVS_MADE 视图，首先需要在数据库管理系统中打开和连接数据源，然后运行包含视图名称的查询语句，例如：

SELECT * FROM ALL_TAB_PRIVS_MADE WHERE PRIVILEGE = ‘SELECT’;

上述语句将列出以“SELECT”（查询）权限授予的表名；其它用户要获取“INSERT”或其他类型的权限，只需要将“SELECT”替换为其他权限即可（如“INSERT”）。

ALL_TAB_PRIVS_MADE describes the object grants for which the current user is the object owner or grantor.

Related View

USER_TAB_PRIVS_MADE describes the object grants for which the current user is the object owner. This view does not display the OWNER column.

Column	Datatype	Description
`GRANTEE`	`VARCHAR2(128)`	Name of the user or role to whom access was granted
`OWNER`	`VARCHAR2(128)`	Owner of the object
`TABLE_NAME`	`VARCHAR2(128)`	Name of the object
`GRANTOR`	`VARCHAR2(128)`	Name of the user who performed the grant
`PRIVILEGE`	`VARCHAR2(40)`	Privilege on the object
`GRANTABLE`	`VARCHAR2(3)`	Indicates whether the privilege was granted with the `GRANT OPTION` (`YES`) or not (`NO`)
`HIERARCHY`	`VARCHAR2(3)`	Indicates whether the privilege was granted with the `HIERARCHY OPTION` (`YES`) or not (`NO`)
`COMMON`	`VARCHAR2(3)`	Indicates how the grant was made. Possible values: `YES` if the privilege was granted commonly (`CONTAINER=ALL` was used) `NO` if the privilege was granted locally (`CONTAINER=ALL` was not used)
`TYPE`	`VARCHAR2(24)`	Type of the object
`INHERITED`	`VARCHAR2(3)`	Indicates whether the privilege grant was inherited from another container (`YES`) or not (`NO`)