SYSCOLPERMSThe SYSCOLPERMS table stores the column permissions that have been
granted but not revoked.
All of the permissions for one (GRANTEE, TABLEID, TYPE, GRANTOR)
combination are specified in a single row in the SYSCOLPERMS table. The keys
for the SYSCOLPERMS table are:
Primary key (GRANTEE, TABLEID, TYPE, GRANTOR)
Unique key (COLPERMSID)
Foreign key (TABLEID references SYS.SYSTABLES)
Column NameTypeLengthNullabilityContentsCOLPERMSIDCHAR36falseUsed by the dependency manager to track the dependency
of a view, trigger, or constraint on the column level permissions.GRANTEEVARCHAR30falseThe authorization ID of the user to whom the privilege
was granted. GRANTORVARCHAR30falseThe authorization ID of the user who granted the privilege.
Privileges can be granted only by the object owner.TABLEIDCHAR36falseThe unique identifier for the table on which the permissions
have been granted.TYPECHAR1falseThe type of column permission: S for SELECT
U for UPDATE
R for REFERENCESCOLUMNSorg.apache.derby.iapi.services.io.FormatableBitSet falseA list of columns to which the privilege applies.