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 table
For 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)