<< SYSROUTINEPERMS system table | SYSSEQUENCES system table >>

SYSSCHEMAS system table

<< SYSROUTINEPERMS system table | SYSSEQUENCES system table >>

Derby Reference Manual

231

Column Name

Type

Length

Nullable

Contents

ROUTINEPERMSID

CHAR

false

Used by the
dependency
manager to track
the dependency
of a view, trigger,
or constraint on
the routine level
permissions

GRANTEE

VARCHAR

128

false

The authorization
ID of the user or
role to which the
privilege is granted

GRANTOR

VARCHAR

128

false

The authorization
ID of the user
who granted the
privilege. Privileges
can be granted
only by the object
owner.

ALIASID

CHAR

false

The ID of
the object of
the required
permission. If
PERMTYPE='E',
the ALIASID is a
reference to the
SYS.SYSALIASES
table. Otherwise,
the ALIASID is a
reference to the
SYS.SYSTABLES
table.

GRANTOPTION

CHAR

false

Specifies if the
GRANTEE is
the owner of the
routine. Valid
values are 'Y' and
'N'.

SYSSCHEMAS system table

The SYSSCHEMAS table describes the schemas within the current database.

The following table shows the contents of the SYSSCHEMAS system table.

Table 54.

SYSSCHEMAS system table

Column Name

Type

Length

Nullable

Contents

SCHEMAID

CHAR

false

Unique identifier for
the schema