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:

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

Table 1. SYSTABLEPERMS system table
Column Name Type Length Nullable Contents
TABLEPERMSID CHAR 36 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 36 false The unique identifier for the table on which the permissions have been granted
SELECTPRIV CHAR 1 false Specifies if the SELECT permission is granted. The valid values are:

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

DELETEPRIV CHAR 1 false Specifies if the DELETE permission is granted. The valid values are:

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

INSERTPRIV CHAR 1 False Specifies if the INSERT permission is granted. The valid values are:

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

UPDATEPRIV CHAR 1 False Specifies if the UPDATE permission is granted. The valid values are:

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

REFERENCESPRIV CHAR 1 false Specifies if the REFERENCE permission is granted. The valid values are:

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

TRIGGERPRIV CHAR 1 false Specifies if the TRIGGER permission is granted. The valid values are:

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

Related reference
REVOKE statement
GRANT statement