Specify a Login

The secure default login parameter specifies a default login for all users who are preauthenticated, but do not have a login in master..syslogins.

Summary Information

Name in pre-11.0 version


Default value


Range of values

0 (followed by another parameter naming the default login)



Display level


Required role

System Security Officer

Use the following syntax to establish the secure default login:
sp_configure "secure default login", 0, default_login_name

where default_login_name is the name of the default login for a user who, although unknown to Adaptive Server, has already been authenticated by a security mechanism. This name must be a valid login in master..syslogins.

For example, to specify “dlogin” as the secure default login, execute:
select sp_configure "secure default login", 0,