The ALL_COL_PRIVS view provides information about column-level object grants where the current user is the object owner, grantor, grantee, or where an enabled role or PUBLIC is the grantee.
| Column name | Data type | Description |
|---|---|---|
GRANTOR |
VARCHAR2(128) |
The name of the user who performed the grant. |
GRANTEE |
VARCHAR2(128) |
The name of the user or role to whom access was granted. |
TABLE_SCHEMA |
VARCHAR2(128) |
The schema of the object. |
TABLE_NAME |
VARCHAR2(128) |
The name of the object. |
COLUMN_NAME |
VARCHAR2(128) |
The name of the column. |
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). |