Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03 |
|
|
PDF · Mobi · ePub |
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
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 | NULL | Description |
---|---|---|---|
GRANTEE |
VARCHAR2(30) |
NOT NULL |
Name of the user or role to whom access was granted |
OWNER |
VARCHAR2(30) |
NOT NUL |
Owner of the object |
TABLE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the object |
COLUMN_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the column |
GRANTOR |
VARCHAR2(30) |
NOT NULL |
Name of the user who performed the grant |
PRIVILEGE |
VARCHAR2(40) |
NOT NULL |
Privilege on the column |
GRANTABLE |
VARCHAR2(3) |
Indicates whether the privilege was granted with the GRANT OPTION (YES ) or not (NO ) |
See Also:
"USER_COL_PRIVS_RECD"