sys-sysprotects-transact-sql.md

title	sys.sysprotects (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/15/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	sysprotects sys.sysprotects_TSQL sys.sysprotects sysprotects_TSQL
dev_langs	TSQL
helpviewer_keywords	sys.sysprotects compatibility view sysprotects system table
ms.assetid	49c9658d-fb51-4c77-94a0-fba699b0102d
author	rothja
ms.author	jroth

sys.sysprotects (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

Contains information about permissions that have been applied to security accounts in the database by using the GRANT and DENY statements.

Important

[!INCLUDEssnoteCompView]

Column name	Data type	Description
id	int	ID of the object to which these permissions apply.
uid	smallint	ID of user or group to which these permissions apply. Overflows or returns NULL if the number of users and roles exceeds 32,767.
action	tinyint	Can have one of the following 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 the following values: 204 = GRANT_W_GRANT 205 = GRANT 206 = DENY
columns	varbinary(8000)	Bitmap of columns to which these SELECT or UPDATE permissions apply. Bit 0 = All columns. Bit 1 = Permissions apply to that column. NULL = No information.
grantor	smallint	User ID of the user that issued the GRANT or DENY permissions. Overflows or returns NULL if the number of users and roles exceeds 32,767.

See Also

Mapping System Tables to System Views (Transact-SQL)
Compatibility Views (Transact-SQL)