This section provides information about check password for digit, a new configuration parameter.
Summary information |
|
---|---|
Name in pre-12.0 version |
N/A |
Default value |
0 |
Range of values |
1, 0 |
Status |
Dynamic |
Display level |
10 |
Required role |
System Security Officer |
The System Security Officer can tell the server to check for at least one character or digit in a password using the server-wide configuration parameter check password for digit. If set, this parameter does not affect existing passwords. By default, checking for digits is off.
To activate check password for digit functionality, enter:
sp_configure "check password for digit", 1
To deactivate check password for digit functionality, enter:
sp_configure "check password for digit", 0