SYSTABLEPERMS

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)
Table 1. SYSTABLEPERMS system table
Column Name Type Length Nullable Contents
TABLEPERMSID CHAR 36 No Used by the dependency manager to track the dependency of a view, trigger, or constraint on the table level permissions
GRANTEE VARCHAR 128 No The authorization ID of the user or role to which the privilege is granted
GRANTOR VARCHAR 128 No The authorization ID of the user who granted the privilege. Privileges can be granted only by the object owner
TABLEID CHAR 36 No The unique identifier for the table on which the permissions have been granted
SELECTPRIV CHAR 1 No Specifies if the SELECT permission is granted. The valid values are:

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

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

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

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

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

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

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

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

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

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

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