syssrvroles

master database only

Description

syssrvroles contains a row for each system or user-defined role.

Columns

The columns for syssrvroles are:

Name

Datatype

Description

srid

int

Server role ID

name

varchar(30)

Name of the role

password

varinary(30)

Password for the role (encrypted)

pwdate

datetime

Date the password was last changed

status

smallint

Bitmap for role status. See Table 12-19

logincount

smallint

Number of failed login attempts; reset to 0 by a successful login.

Table 12-19 lists the bit representations for the status column:

Table 12-19: status control bits in the syssrvroles table

Decimal

Hex

Status

2

0x2

Role is locked

4

0x4

Role is expired

Indexes

Unique clustered index On srid