The following table shows the contents of the SYSPERMS system table.
SYSPERMS system table
For each column in the SYSPERMS system table, this table provides its data type, its length in bytes, whether it is nullable, and a description of its contents.
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'.