Export (0) Print
Expand All
Expand Minimize
2 out of 2 rated this helpful - Rate this topic

sysprotects

SQL Server 2000

Contains information about permissions that have been applied to security accounts with the GRANT and DENY statements. This table is stored in each database.

Column name Data type Description
id int ID of object to which these permissions apply.
uid smallint ID of user or group to which these permissions apply.
action tinyint Can have one of these permissions:

26  = REFERENCES
178 = CREATE FUNCTION
193 = SELECT
195 = INSERT
196 = DELETE
197 = UPDATE
198 = CREATE TABLE
203 = CREATE DATABASE
207 = CREATE VIEW
222 = CREATE PROCEDURE
224 = EXECUTE
228 = BACKUP DATABASE
233 = CREATE DEFAULT
235 = BACKUP LOG
236 = CREATE RULE

protecttype tinyint Can have these values:

204 = GRANT_W_GRANT
205 = GRANT
206 = DENY

columns varbinary(4000) Bitmap of columns to which these SELECT or UPDATE permissions apply. Bit 0 indicates all columns; bit 1 means permissions apply to that column and NULL means no information.
grantor smallint User ID of the user who issued the GRANT or REVOKE permissions.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.