SYSROLES system table
Derby Reference Manual
229
Column Name
Type
Length
Nullable
Contents
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'.
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 (the result of a
)
· 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 52.
SYSROLES system table
Column Name
Type
Length
Nullable
Contents
UUID
CHAR
36
false
A unique identifier
for this role
ROLEID
VARCHAR
128
false
The role name,
after conversion to
case normal form
GRANTEE
VARCHAR
128
false
If the row
represents a role
grant, this is the
authorization
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.
GRANTOR
VARCHAR
128
false
This is the
authorization
identifier of the
user that granted
this role. If the row
represents a role
definition, this is
the authorization
identifier
