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 |
N/A |
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 |
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.
select sp_configure "secure default login", 0, dlogin