# 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'.

Parent topic: Derby system tables