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
30
False
The authorization ID of the user to whom the privilege
is granted.
GRANTOR
VARCHAR
30
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)