Oracle教程 2023-02-23

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

本站中文解释

Oracle视图 ALL_COL_PRIVS_MADE 是一个数据字典视图是用于显示当前用户针对表中某个列拥有何种权限。该视图包含以下列：

TableOwner：列拥有权限表的拥有者

TableName：列拥有权限表的名称

ColumnName：拥有权限的列的名称

Grantor：授予该列权限的用户

Grantee：被以授予该权限的用户

Privilege：给予的权限

Grantable：是否可以将权限授予给他人

使用 Oracle 视图ALL_COL_PRIVS_MADE，你可以查询当前用户对表中特定列拥有何种权限，例如：

SELECT table_owner, table_name, column_name, privilege, grantor, grantee
FROM all_col_privs_made
WHERE table_name = ‘MY_TABLE’
AND column_name = ‘MY_COLUMN’;

通过执行这个语句，可以返回当前用户在表MY_TABLE的列MY_COLUMN上面拥有的具体权限：Grantor(授予该权限的用户)，Grantee(被以授予该权限的用户), 以及 Privilege(给予的权限)。

官方英文解释

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

Related View

USER_COL_PRIVS_MADE describes the column 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
`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`)

本站中文解释

官方英文解释

相关推荐