Adaptive Server includes several controls for setting policies for logins, roles, and passwords for internal authentication.
In Adaptive Server the system security officer can:
Specifying the maximum allowable number of times an invalid password can be entered for a login or role before that login or role is automatically locked
Logging in after a lost password
Locking and unlocking logins and roles manually
Displaying login password information
Specify the minimum password length required server-wide or for a specific login or role
Checking for password complexity of logins
Enabling custom password checks of logins
Setting the password expiration interval
Securing login passwords stored on a disk and in memory
Using only the SHA-256 algorithm for storing passwords on disk
Login password character set considerations
Upgrading and downgrading behavior
Last login and locking inactive login accounts
Using passwords in a high availability environment
Negative values may be used for user IDs (uid).
The server user ID (suid) associated with a group or a role in sysusers is not equal to the negation of their user ID (uid). Every suid associated with a group or a role in sysusers is set to -2 (INVALID_SUID).
