Column name
|
Data type
|
Description
|
TABLE_SYSID
|
INTEGER
|
System identifier of the table. |
PRIVILEGE_TYPE
|
CHAR(20)
|
One of:
"DELETE"
"INSERT"
"LOAD"
"REFERENCES"
"SELECT"
"UPDATE"
"TRIGGER". |
GRANTEE
|
VARCHAR(128)
|
The name of the ident to whom the table privilege was granted. |
GRANTOR
|
VARCHAR(128)
|
The name of the ident granting the table privilege. |
IS_GRANTABLE
|
CHAR(3)
|
One of:
"YES" = WITH GRANT OPTION is held with the privilege
"NO" = WITH GRANT OPTION is not held with the privilege. |
IS_INSTEAD_OF
|
CHAR(3)
|
One of:
"NO" = The privilege was granted explicitly
"YES" = The privilege was granted implicitly when an instead of trigger was created. |
IS_ON_TABLE
|
CHAR(3)
|
One of:
"NO" = The privilege was granted on individual columns
"YES" = The privilege was granted on the complete table. |
ALL_COLUMNS
|
CHAR(3)
|
One of:
"YES" = the privilege was granted on the table and therefore applies to all table columns, including new ones added
"NO" = the privilege only applies to the table columns explicitly specified when the privilege was granted. |
