1.0

Table 21: SYSKEYS system table
ContentsNullableLengthTypeColumn Name
Unique identifier for constraintfalse36CHARCONSTRAINTID
Unique identifier for backing
index
false36CHARCONGLOMERATEID
SYSROLES system table
The SYSROLES table stores the roles in the database.
A row in the SYSROLES table represents one of the following:
• A role definition
• A role grant
The keys for the SYSROLES table are:
• Primary key (GRANTEE, ROLEID, GRANTOR)
• Unique key (UUID)
The following table shows the contents of the SYSROLES system table.
Table 22: SYSROLES system table
ContentsNullableLengthTypeColumn Name
A unique identifier for this rolefalse36CHARUUID
The role name, after conversion
to case normal form
false128VARCHARROLEID
If the row represents a role
grant, this is the authorization
false128VARCHARGRANTEE
identifier of a user or role to
which this role is granted. If the
row represents a role definition,
this is the database owner's user
name.
This is the authorization
identifier of the user that granted
false128VARCHARGRANTOR
this role. If the row represents a
role definition, this is the
authorization identifier
_SYSTEM. If the row
represents a role grant, this is
the database owner's user name
(since only the database owner
can create and grant roles).
A role definition is modelled as
a grant from _SYSTEM to the
false1CHARWITHADMINOPTION
database owner, so if the row
represents a role definition, the
value is always 'Y'. This means
617
System Tables