Export (0) Print
Expand All
Expand Minimize

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft