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 column information for the SYSTABLEPERMS table is listed in the following table:

Column Name Type Length Nullability 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.

'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)

REFERENCEPRIV 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