Export (0) Print
Expand All
1 out of 3 rated this helpful - Rate this topic

sys.syspermissions (Transact-SQL)

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

ms188370.note(en-US,SQL.90).gifImportant:
This SQL Server 2000 system table is included as a view for backward compatibility. We recommend that you use the current SQL Server system views instead. To find the equivalent system view or views, see Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views. This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

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

Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.

actmod

smallint

Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.

seladd

varbinary(4000)

Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.

selmod

varbinary(4000)

Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.

updadd

varbinary(4000)

Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.

updmod

varbinary(4000)

Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.

refadd

varbinary(4000)

Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.

refmod

varbinary(4000)

Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.