SYSPERMS system table

The SYSPERMS table describes the USAGE permissions for sequence generators, user-defined types, and user-defined aggregates.

The following table shows the contents of the SYSPERMS system table.

Table 1. SYSPERMS system table
Column Name Type Length Nullable Contents
UUID CHAR 36 false The unique ID of the permission. This is the primary key.
OBJECTTYPE VARCHAR 36 false The kind of object receiving the permission. Valid values are 'SEQUENCE', 'TYPE', and 'DERBY AGGREGATE'.
OBJECTID CHAR 36 false The UUID of the object receiving the permission. For sequence generators, the only valid values are SEQUENCEIDs in the SYS.SYSSEQUENCES table. For user-defined types and user-defined aggregates, the only valid values are ALIASIDs in the SYS.SYSALIASES table if the SYSALIASES row describes a user-defined type or user-defined aggregate.
PERMISSION CHAR 36 false The type of the permission. The only valid value is 'USAGE'.
GRANTOR VARCHAR 128 false The authorization ID of the user who granted the privilege. Privileges can be granted only by the object owner.
GRANTEE VARCHAR 128 false The authorization ID of the user or role to which the privilege was granted
ISGRANTABLE CHAR 1 false If the GRANTEE is the owner of the sequence generator, user-defined type, or user-defined aggregate, this value is 'Y'. If the GRANTEE is not the owner of the sequence generator, user-defined type, or user-defined aggregate, this value is 'N'.