sys-syspermissions-transact-sql.md

title	sys.syspermissions (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	sys.syspermissions_TSQL syspermissions_TSQL sys.syspermissions syspermissions
dev_langs	TSQL
helpviewer_keywords	syspermissions system table sys.syspermissions compatibility view
ms.assetid	ba9a9a88-55d2-41a7-b09b-342e8b9a54c5
author	rothja
ms.author	jroth

sys.syspermissions (Transact-SQL)

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

Contains information about permissions granted and denied to users, groups, and roles in the database.

Important

[!INCLUDEssnoteCompView]

Column name	Data type	Description
id	int	ID of the object for object permissions. 0 = Statement permissions.
grantee	smallint	ID of the user, group, or role affected by the permission.
grantor	smallint	ID of the user, group, or role that granted or denied the permission.
actadd	smallint	[!INCLUDEssInternalOnly]
actmod	smallint	[!INCLUDEssInternalOnly]
seladd	varbinary(4000)	[!INCLUDEssInternalOnly]
selmod	varbinary(4000)	[!INCLUDEssInternalOnly]
updadd	varbinary(4000)	[!INCLUDEssInternalOnly]
updmod	varbinary(4000)	[!INCLUDEssInternalOnly]
refadd	varbinary(4000)	[!INCLUDEssInternalOnly]
refmod	varbinary(4000)	[!INCLUDEssInternalOnly]

See Also

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