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
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 |
|---|---|---|---|
GRANTOR |
VARCHAR2(30) |
NOT NULL |
Name of the user who performed the grant |
GRANTEE |
VARCHAR2(30) |
NOT NULL |
Name of the user to whom access was granted |
TABLE_SCHEMA |
VARCHAR2(30) |
NOT NULL |
Schema of the object |
TABLE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the object |
COLUMN_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the column |
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: