COLUMN_PRIVILEGES
Records table or view columns that depend on other objects in the database.
.
Column name
|
Data type
|
Description
|
TABLE_SYSID
|
INTEGER
|
System identifier for the table or view. |
COLUMN_NAME
|
VARCHAR(128)
|
The name of the table or view column. |
PRIVILEGE_TYPE
|
CHAR(20)
|
One of:
"INSERT"
"REFERENCES"
"SELECT"
"UPDATE". |
GRANTEE
|
VARCHAR(128)
|
The name of the ident to which the privilege was granted. |
GRANTOR
|
VARCHAR(128)
|
The name of the ident granting the privilege. |
IS_GRANTABLE
|
CHAR(3)
|
One of:
"NO" = WITH GRANT OPTION is not held for the privilege
"YES" = WITH GRANT OPTION is held for the privilege. |
IS_INSTEAD_OF
|
CHAR(3)
|
One of:
"NO" = The privilege has been granted explicitly
"YES" = The privilege is granted because an instead of trigger has been defined on the view to which the column belongs. |
Primary key: TABLE_SYSID, COLUMN_NAME, PRIVILEGE_TYPE, GRANTEE, GRANTOR
Secondary index: GRANTEE
Secondary index: GRANTOR
