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 |
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
