As a standalone product, Adaptive Server ensures security by:
Storing login information for all database users in the master.dbo.syslogins table. Passwords stored are encrypted.
Requiring client applications to specify the login name and password of a database user, either programmatically or with a command-line option.
Checking the user name and password against the information in syslogins, and accepting or rejecting the login accordingly.