The SYSTABLEPERMS table stores the table permissions that have been granted but not revoked.
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) |
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. 'y' (non-grantable privilege) |
UPDATEPRIV | CHAR | 1 | False | Specifies if the UPDATE permission is granted. The valid
values are: 'y' (non-grantable privilege) |
REFERENCEPRIV | 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) |