syssrvroles

master database only

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

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 null	Date the password was last changed
status	smallint	Bitmap for role status. See Table 1-21
logincount	smallint	Number of failed login attempts; reset to 0 by a successful login.

Table 1-21 lists the bit representations for the status column:

**Table 1-21: status control bits in the syssrvroles table**
Decimal	Hex	Status
2	0x2	Role is locked
4	0x4	Role is expired

Unique clustered index On srid