master database only
syslogins contains one row for each valid Adaptive Server user account.
The columns for syslogins are:
Name |
Datatype |
Description |
|---|---|---|
suid |
int |
Server user ID |
status |
smallint |
Status of the account (see Table 1-16) |
accdate |
datetime |
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 null |
Name of database in which to put user when connection established |
name |
sysname |
Login name of user |
password |
varbinary(30) null |
Password of user (encrypted) |
language |
varchar(30) null |
User’s default language |
pwdate |
datetime null |
Date the password was last changed |
audflags |
int null |
User’s audit settings |
fullname |
varchar(30) null |
Full name of the user |
srvname |
varchar(30) null |
Name of server to which a passthrough connection must be established if the AUTOCONNECT flag is turned on |
logincount |
smallint null |
Number of failed login attempts; reset to 0 by a successful login |
procid |
int null |
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 1-16 lists the bit representations for the status column:
Unique clustered index on suid
Unique nonclustered index on name
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
