Oracle教程 2023-02-23

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

本站中文解释

ALL_COL_PRIVS_RECD 视图是Oracle提供的一种系统视图，它提供了有关访问特定用户或角色授予特定对象的某个**受保护列权限**的详细信息，它可以帮助您查询和确定当前用户和角色的可访问性。

使用ALL_COL_PRIVS_RECD视图，您可以根据接收人(GRANTEE)，对象(TABLE_NAME)，列(COLUMN_NAME)和授权(PRIVILEGE)等字段查询某个GRANTEE拥有哪些权限及其对应的列名。例如，您可以将所有标识为GRANTEE的用户检索出来，以查看该用户从哪些用户或角色处获得了SELECT，INSERT，UPDATE和DELETE等权限。

使用该视图需要以下步骤：

(1) 首先连接到Oracle数据库；
(2) 构建查询语句，添加ALL_COL_PRIVS_RECD视图中的字段，比如GRANTEE，TABLE_NAME，COLUMN_NAME，PRIVILEGE等；
(3) 执行查询语句，查询结果将以字段值的形式返回，便于用户精确地查看某个用户拥有哪些权限；
(4) 使用结果。

官方英文解释

ALL_COL_PRIVS_RECD describes the following types of grants:

Column object grants for which the current user is the grantee
Column object grants for which an enabled role or PUBLIC is the grantee

Related View

USER_COL_PRIVS_RECD describes the column 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
`COLUMN_NAME`	`VARCHAR2(128)`	Name of the column
`GRANTOR`	`VARCHAR2(128)`	Name of the user who performed the grant
`PRIVILEGE`	`VARCHAR2(40)`	Privilege on the column
`GRANTABLE`	`VARCHAR2(3)`	Indicates whether the privilege was granted with the `GRANT 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)
`INHERITED`	`VARCHAR2(3)`	Indicates whether the privilege grant was inherited from another container (`YES`) or not (`NO`)

本站中文解释

官方英文解释

相关推荐