| TABLE 1: The SQL Server sysprotects Table Fields |
| Column Name | Description |
| ID | The object identifier (from sysobjects) the |
| permission applies to. |
| UID | The user/group identifier (from sysusers) the |
| permission applies to. |
| ACTION | The type of permission being granted (193 = Select, 195 = Insert, 197 = Update, 196 = Delete). |
| PROTECTTYPE | The type of protection action (205 = Grant, 206 = Revoke). |
| COLUMNS | The columns that this protection action affects. This field is a bitmap table of column entries. A value of 0x01 (hex) means all columns. Unless you specifically use column-level permissions, this value will always be 0x01. |
| GRANTOR | The user identifier (from sysusers) of the individual who created this permission entry. |