sysprotects

#

Column

Datatype

Len

Prec

Scale

Null

Default

Rule

Comments

1

id

int

4

No

2

uid

int

4

No

3

action

smallint

2

No

4

protecttype

tinyint

1

No

5

columns

varbinary

133

Yes

6

grantor

int

4

Yes

Name

Attributes

Segment

Columns

sysprotects

unique
clustered

system

id, action, grantor, uid, protecttype

#

Columns

1

id
uid
action

1

sp_commonkey references table sysusers.
Column uid to sysusers.uid

1

sp_commonkey coming from table sysobjects.
sysobjects.id to column id

#

User/Group

Protect-Type

Action

Column Mask

Grantor

1

public

grant

select

All

dbo