Chapter 5: Setting Configuration Parameters

secure default login

Summary information
Default value	0
Range of values	0 (followed by another parameter naming the default login)
Status	Dynamic
Display level	Intermediate
Required role	System Security Officer
Configuration group	Security Related

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

Establish the secure default login with:

sp_configure "secure default login", 0,
    default_login_name

where:

secure default login – is the name of the parameter.
0 – is a required parameter because the second parameter of sp_configure must be a numeric value.
default_login_name – is the name of the default login for a user who is unknown to Adaptive Server, but who has already been authenticated by a security mechanism. The login name must be a valid login in master..syslogins.

For example, to specify “dlogin” as the secure default login, type:

sp_configure "secure default login", 0, dlogin