sysprotects

Transact-SQL Reference

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
178 = CREATE FUNCTION
193 = SELECT
195 = INSERT
196 = DELETE
197 = UPDATE
198 = CREATE TABLE
203 = CREATE DATABASE
207 = CREATE VIEW
222 = CREATE PROCEDURE
224 = EXECUTE
228 = BACKUP DATABASE
233 = CREATE DEFAULT
235 = BACKUP LOG
236 = CREATE RULE

protecttype tinyint Can have these values:

204 = GRANT_W_GRANT
205 = GRANT
206 = REVOKE

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.