Chapter 1: System Tables

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	varbinary(30) null	Password for the role (encrypted)
pwdate	datetime null	Date the password was last changed
status	smallint null	Bitmap for role status (see Table 1-22)
logincount	smallint null	Number of failed login attempts; reset to 0 by a successful login

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

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