Each row represents a user, group, or role that has been granted one or more privileges on a column.
Column Name | Data Type | Nullable | Description |
---|---|---|---|
GRANTOR | VARCHAR (128) | Grantor of a privilege. | |
GRANTORTYPE | CHAR (1) |
|
|
GRANTEE | VARCHAR (128) | Holder of a privilege. | |
GRANTEETYPE | CHAR (1) |
|
|
TABSCHEMA | VARCHAR (128) | Schema name of the table or view on which the privilege is held. | |
TABNAME | VARCHAR (128) | Unqualified name of the table or view on which the privilege is held. | |
COLNAME | VARCHAR (128) | Name of the column to which this privilege applies. | |
COLNO | SMALLINT | Column number of this column within the table (starting with 0). | |
PRIVTYPE | CHAR (1) |
|
|
GRANTABLE | CHAR (1) |
|
|
Note:
|