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 |
The secure default login parameter specifies a default login for all users who are preauthenticated, but do not have a login in master..syslogins.
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, dlogin
