SYSCOLPERMS system tableThe SYSCOLPERMS table stores the column permissions that have been
granted but not revoked.system tablesSYSCOLPERMSpermissionsSYSCOLPERMS system tableSYSCOLPERMS system table
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.TYPECHAR1FalseIf the privilege is non-grantable, the valid values are: 's' for SELECT
'u' for UPDATE
'r' for REFERENCES
If the privilege is grantable, the valid values are: 'S' for SELECT
'U' for UPDATE
'R' for REFERENCESCOLUMNSorg.apache.derby.iapi.services.io.FormatableBitSet FalseA list of columns to which the privilege applies.