[Home] [Help] [Dependency Information]
Object Name: | DBA_COL_PRIVS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
All grants on columns in the database
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GRANTEE | VARCHAR2 | (128) | Name of the user to whom access was granted | |
OWNER | VARCHAR2 | (128) | Username of the owner of the object | |
TABLE_NAME | VARCHAR2 | (128) | Name of the object | |
COLUMN_NAME | VARCHAR2 | (128) | Name of the column | |
GRANTOR | VARCHAR2 | (128) | Name of the user who performed the grant | |
PRIVILEGE | VARCHAR2 | (40) | Column Privilege | |
GRANTABLE | VARCHAR2 | (3) | Privilege is grantable | |
COMMON | VARCHAR2 | (3) | Privilege was granted commonly |
Cut, paste (and edit) the following text to query this object:
SELECT GRANTEE
, OWNER
, TABLE_NAME
, COLUMN_NAME
, GRANTOR
, PRIVILEGE
, GRANTABLE
, COMMON
FROM SYS.DBA_COL_PRIVS;
|
|
|