<< SYSSTATISTICS system table | REFERENCESPRIV >>

SYSTABLEPERMS system table

<< SYSSTATISTICS system table | REFERENCESPRIV >>

Derby Reference Manual

235

SYSTABLEPERMS system table

The SYSTABLEPERMS table stores the table permissions that have been granted but
not revoked.

All of the permissions for one (GRANTEE, TABLEID, GRANTOR) combination
are specified in a single row in the SYSTABLEPERMS table. The keys for the
SYSTABLEPERMS table are:

· Primary key (GRANTEE, TABLEID, GRANTOR)
· Unique key (TABLEPERMSID)
· Foreign key (TABLEID references SYS.SYSTABLES)

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

Table 58.

SYSTABLEPERMS system table

Column Name

Type

Length

Nullable

Contents

TABLEPERMSID

CHAR

false

Used by the
dependency
manager to track
the dependency
of a view, trigger,
or constraint on
the table 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

TABLEID

CHAR

false

The unique
identifier for the
table on which the
permissions have
been granted

SELECTPRIV

CHAR

false

Specifies if
the SELECT
permission is
granted. The valid
values are:

'y' (non-grantable
privilege)
'Y' (grantable
privilege)
'N' (no privilege)