| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-01 |
|
|
View PDF |
| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-01 |
|
|
View PDF |
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 |
|---|---|---|---|
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) |
