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(128) null	Password for the role (encrypted) and readable only by a user with sso_role
pwdate	datetime null	Date the password was last changed
status	smallint null	Bitmap for role status (see Table 1-26)
logincount	smallint null	Number of failed login attempts; reset to 0 by a successful login

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

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