Oracle 视图 ALL_COL_PRIVS 官方解释,作用,如何使用详细说明
本站中文解释
ALL_COL_PRIVS视图用于显示当前用户或其它用户拥有的表或视图的列权限,其主要由如下6个字段组成:
GRANTEE: 拥有权限的用户或程序
TABLE_SCHEMA: 表或视图所属的Schema
TABLE_NAME: 表或视图名
COLUMN_NAME: 列名
PRIVILEGE: 权限类型
IS_GRANTABLE: 用户是否可将权限授予其它用户
使用ALL_COL_PRIVS视图可以很容易查询指定用户(GRANTEE)拥有某张表(TABLE_NAME)中列(COLUMN_NAME)的权限(PRIVILEGE),以及是否可将权限授予其他用户(IS_GRANTABLE)。例如:
查询当前登录用户拥有表 USERS 中所有列的权限
SELECT GRANTEE, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, PRIVILEGE, IS_GRANTABLE
FROM ALL_COL_PRIVS
WHERE GRANTEE = USER AND TABLE_NAME = ‘USERS’;
官方英文解释
ALL_COL_PRIVS
describes the following types of grants:
-
Column object grants for which the current user is the object owner, grantor, or grantee
-
Column object grants for which an enabled role or
PUBLIC
is the grantee
Related Views
-
DBA_COL_PRIVS
describes all column object grants in the database. -
USER_COL_PRIVS
describes the column object grants for which the current user is the object owner, grantor, or grantee.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
Name of the user who performed the grant |
|
|
|
Name of the user or role to whom access was granted |
|
|
|
Schema of the object |
|
|
|
Name of the object |
|
|
|
Name of the column |
|
|
|
Privilege on the column |
|
|
|
Indicates whether the privilege was granted with the |
|
|
|
Indicates how the grant was made. Possible values:
|
|
|
|
Indicates whether the privilege grant was inherited from another container ( |
See Also:
-
“DBA_COL_PRIVS”
-
“USER_COL_PRIVS”