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