Login profile attributes

Table 3-5 summarizes the attributes of login profiles. Login profile attributes are stored in syslogins, sysloginroles and master.dbo.sysattributes.

**Table 3-5: Login Profile Attributes**
Attribute	Description
default database	Default database in Adaptive Server.
default language	Default language.
login script	Valid stored procedure. Stored procedures used as a login script through create login, alter login, create login profile, and alter login profile, is restricted to 120 characters.
auto activated roles	Previously granted user-defined roles that are not password-protected that must be automatically activated on login. An error is generated if the role specified is not granted to the login. By default, user-defined roles are not automatically activated on login.
authenticate with	Specifies the mechanism used for authenticating the login account. If authenticate with authentication mechanism is not specified, the value ANY will be used for the login account.
track lastlogin	Enables last login updates.
stale period	Indicates the duration a login account is allowed to remain inactive before it is locked due to inactivity.
profile id	Specifies a database in Adaptive Server.