Storing login information, requiring client applications to specify the login name and password of a database user, and checking the user name and password are the ways Adaptive Server enforces security.
Storing login information for all database users in the master.dbo.syslogins table. Stored passwords 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.