TABLE 1: The SQL Server sysprotects Table Fields
Column NameDescription
IDThe object identifier (from sysobjects) the
permission applies to.
UIDThe user/group identifier (from sysusers) the
permission applies to.
ACTIONThe type of permission being granted (193 = Select, 195 = Insert, 197 = Update, 196 = Delete).
PROTECTTYPEThe type of protection action (205 = Grant, 206 = Revoke).
COLUMNSThe 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.
GRANTORThe user identifier (from sysusers) of the individual who created this permission entry.