syslogins

master database only

Description

syslogins contains one row for each valid Adaptive Server user account.

Columns

The columns for syslogins are:

Name	Datatype	Description
suid	int	Server user ID
status	smallint	Status of the account (see Table 12-13)
accdate	datetimn	Date totcpu and totio were last cleared
totcpu	int	CPU time accumulated by login
totio	int	I/O accumulated by login
spacelimit	int	Reserved
timelimit	int	Reserved
resultlimit	int	Reserved
dbname	sysname	Name of database in which to put user when connection established
name	sysname	Login name of user
password	varbinary(30)	Password of user (encrypted)
language	varchar(30)	User’s default language
pwdate	datetime	Date the password was last changed
audflags	int	User’s audit settings
fullname	varchar(30)	Full name of the user
srvname	varchar(30)	Name of server to which a passthrough connection must be established if the AUTOCONNECT flag is turned on.
logincount	smallint	Number of failed login attempts; reset to 0 by a successful login.
procid	int	Stores the login trigger registered with the login script option in sp_modifylogin.

On the Adaptive Server distribution media, syslogins contains an entry in which the name is “sa”, the suid is 1, and the password is null. It also contains the entry “probe” with an unpublished password. The login “probe” and the user “probe” exist for the two phase commit probe process, which uses a challenge and response mechanism to access Adaptive Server.

Table 12-13 lists the bit representations for the status column:

**Table 12-13: status control bits in the syslogins table**
Decimal	Hex	Status
1	0x1	Password contains fewer than 6 characters or is NULL
2	0x2	Account is locked
4	0x4	Password has expired

Indexes

Unique clustered index On suid

Unique nonclustered index On name