Transact-SQL Reference
sysprotects
Contains information about permissions that have been applied to security accounts with the GRANT and DENY statements. This table is stored in each database.
Column name | Data type | Description |
---|---|---|
id | int | ID of object to which these permissions apply. |
uid | smallint | ID of user or group to which these permissions apply. |
action | tinyint | Can have one of these permissions:
26 = REFERENCES |
protecttype | tinyint | Can have these values:
204 = GRANT_W_GRANT |
columns | varbinary(4000) | Bitmap of columns to which these SELECT or UPDATE permissions apply. Bit 0 indicates all columns; bit 1 means permissions apply to that column and NULL means no information. |
grantor | smallint | User ID of the user who issued the GRANT or REVOKE permissions. |