Oracle教程 2023-02-23

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

？

ALL_TAB_PRIVS_RECD视图用于显示当前用户在每个表上的允许和禁止的权限。它主要包括表名，权限种类，权限对象，对象的类型，用于授予的登录类型等列。你可以使用它来查询给定用户的Oracle表权限。

使用方法：
查询当前用户在哪些表上具有什么权限：
SELECT * FROM ALL_TAB_PRIVS_RECD;

查看指定用户 user_name 在指定表 table_name 上具有什么权限：
SELECT * FROM ALL_TAB_PRIVS_RECD WHERE TABLE_NAME = ‘table_name’ AND GRANTEE = ‘user_name’;

ALL_TAB_PRIVS_RECD describes object grants.

ALL_TAB_PRIVS_RECD describes the following types of grants:

Related View

USER_TAB_PRIVS_RECD describes the object grants for which the current user is the grantee. This view does not display the GRANTEE 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`)