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)