<< SYSROLES system table | SYSSCHEMAS system table >>

SYSROUTINEPERMS system table

<< SYSROLES system table | SYSSCHEMAS system table >>

Derby Reference Manual

230

Column Name

Type

Length

Nullable

Contents

_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).

WITHADMINOPTION

CHAR

false

A role definition
is modelled as
a grant from
_SYSTEM to
the database
owner, so if the
row represents a
role definition, the
value is always 'Y'.
This means that
the creator (the
database owner)
is always allowed
to grant the newly
created role.
Currently roles
cannot be granted
WITH ADMIN
OPTION, so if the
row represents
a role grant, the
value is always 'N'.

ISDEF

CHAR

false

If the row
represents a role
definition, this
value is 'Y'. If the
row represents
a role grant, the
value is 'N'.

SYSROUTINEPERMS system table

The SYSROUTINEPERMS table stores the permissions that have been granted to
routines.

Each routine EXECUTE permission is specified in a row in the SYSROUTINEPERMS
table. The keys for the SYSROUTINEPERMS table are:

· Primary key (GRANTEE, ALIASID, GRANTOR)
· Unique key (ROUTINEPERMSID)
· Foreign key (ALIASID references SYS.SYSALIASES)

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

Table 53.

SYSROUTINEPERMS system table