Consider whether to allow only users who are defined
as valid logins to use Adaptive Server or to allow any user with
the default login to use Adaptive Server.
When a user logs in to Adaptive Server with an authenticated credential, Adaptive Server:
-
Checks that the user is a valid user in
master..syslogins.
-
If the user name appears, Adaptive Server accepts the login
without requiring a password.
-
If the user name does not appear, Adaptive Server performs step
2.
-
Checks that a default secure login is defined in
master..syslogins.
Note: You must add the default login in master..syslogins and
use sp_configure to define the default.