The SYSPERMS table describes the USAGE permissions for sequence generators and user-defined types.
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. The only valid values are 'SEQUENCE' and 'TYPE'. |
| 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, the only valid values are ALIASIDs in the SYS.SYSALIASES table if the SYSALIASES row describes a user-defined type. |
| 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 or user-defined type, this value is 'Y'. If the GRANTEE is not the owner of the sequence generator or user-defined type, this value is 'N'. |