Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
syspermissions
Collapse the table of content
Expand the table of content

syspermissions

SQL Server 2000

Contains information about permissions granted and denied to users, groups, and roles in the database. This table is stored in each database.

Column name Data type Description
id int ID of the object for object permissions; 0 for 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 revoked the permission.
actadd smallint For internal use only.
actmod smallint For internal use only.
seladd varbinary(4000) For internal use only.
selmod varbinary(4000) For internal use only.
updadd varbinary(4000) For internal use only.
updmod varbinary(4000) For internal use only.
refadd varbinary(4000) For internal use only.
refmod varbinary(4000) For internal use only.

Show:
© 2015 Microsoft