The USER_COL_PRIVS view provides information about the column object grants for which the current user is the object owner, grantor, or grantee.
| Column name | Data type | Description |
|---|---|---|
GRANTEE |
VARCHAR2(128) |
The name of the user or role to whom access was granted. |
OWNER |
VARCHAR2(128) |
The owner of the object. |
TABLE_NAME |
VARCHAR2(128) |
The name of the object. |
COLUMN_NAME |
VARCHAR2(128) |
The name of the column. |
GRANTOR |
VARCHAR2(128) |
The name of the user who performed the grant. |
PRIVILEGE |
VARCHAR2(40) |
The privilege on the column. The possible values are:
|
GRANTABLE |
VARCHAR2(3) |
Specifies whether the privilege was granted with the GRANT OPTION (YES) or not (NO). |
COMMON |
VARCHAR2(3) |
Specifies how the privilege was granted. The possible values are:
|
INHERITED |
VARCHAR2(3) |
Specifies whether the privilege grant was inherited from another container (YES) or not (NO). |