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 |
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:
Decimal |
Hex |
Status |
|---|---|---|
2 |
0x2 |
Role is locked |
4 |
0x4 |
Role is expired |
