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:
The following table shows the contents of the SYSTABLEPERMS system table.
| 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) |
| DELETEPRIV | CHAR | 1 | false | Specifies if the DELETE permission is granted. The valid
values are: 'y' (non-grantable privilege) |
| INSERTPRIV | CHAR | 1 | False | Specifies if the INSERT permission is granted. The valid
values are: 'y' (non-grantable privilege) |
| UPDATEPRIV | CHAR | 1 | False | Specifies if the UPDATE permission is granted. The valid
values are: 'y' (non-grantable privilege) |
| REFERENCESPRIV | CHAR | 1 | false | Specifies if the REFERENCE permission is granted. The valid
values are: 'y' (non-grantable privilege) |
| TRIGGERPRIV | CHAR | 1 | false | Specifies if the TRIGGER permission is granted. The valid
values are: 'y' (non-grantable privilege) |