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	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
locksuid	int null	The user who locked the role.
lockreason	int null	The reason why a role was locked.
lockdate	datetime null	The date and time a role was locked.

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

Indexes

Unique clustered index on srid