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

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.

SYSTABLEPERMS system tableFor each column in the SYSTABLEPERMS system table, this table provides its data type, its length in bytes, whether it is nullable, and a description of its contents. 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)