1.0

ContentsNullableLengthTypeColumn Name
Description of the columns
referenced by a CHECK
CONSTRAINT definition
false2,147,483,647com.vmware.sqlfire.internal.catalog.ReferencedColumnsREFERENCEDCOLUMNS
Note: This class is not
part of the public API.
SYSCOLPERMS system table
The 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)
The following table shows the contents of the SYSCOLPERMS system table.
Table 14: SYSCOLPERMS system table
ContentsNullableLengthTypeColumn Name
Used by the dependency
manager to track the
false36CHARCOLPERMSID
dependency of a view, trigger,
or constraint on the column
level permissions
The authorization ID of the user
or role to which the privilege
was granted
false128VARCHARGRANTEE
The authorization ID of the user
who granted the privilege.
false128VARCHARGRANTOR
Privileges can be granted only
by the object owner
The unique identifier for the
table on which the permissions
have been granted
false36CHARTABLEID
If the privilege is non-grantable,
the valid values are:
's' for SELECT
false1CHARTYPE
'u' for UPDATE
'r' for REFERENCES
If the privilege is grantable, the
valid values are:
'S' for SELECT
611
System Tables