Navigation

	Home Page
	Index
	All Pages

Quick Search
Advanced Search »

Contributor Links

	Create a new Page
	Administration
	File Management
	Login/Logout
	Your Profile

Other Wiki Sections

Software

syspermissions System Table - 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.