<< SYSKEYS system table | SYSROLES system table >>

OBJECTTYPE

<< SYSKEYS system table | SYSROLES system table >>

Derby Reference Manual

228

Column Name

Type

Length

Nullable

Contents

UUID

CHAR

false

The unique ID of
the permission.
This is the primary
key.

OBJECTTYPE

VARCHAR

false

The kind of
object receiving
the permission.
The only valid
values are
'SEQUENCE' and
'USER-DEFINED
TYPE'.

OBJECTID

CHAR

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

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

false

If the GRANTEE
is the owner of
the sequence