The protecttype column in sysprotects adds a new value for granting permission to grant permissions. This is referred to as GRANT WITH GRANT. The new value for GRANT WITH GRANT is 204.
The system table sysprotects now has an additional column called grantor. This column has a smallint datatype.
The sysprotects table also has a clustered index on the columns id, action, grantor, uid, and protecttype. The value of grantor defaults to that of the object owner. The create database objects privilege is NULL.
| Column | Datatype | Description |
|---|---|---|
| protecttype | tinyint | The protecttype column can have these values:
204 GRANT_W_GRANT |
| grantor | smallint | The user_id of the user who issued the GRANT or REVOKE permission. |