This section provides information about maximum failed logins, a new configuration parameter.
Summary information |
|
---|---|
Name in pre-12.0 version |
N/A |
Default value |
0 |
Range of values |
0 – 32767 |
Status |
Dynamic |
Display level |
10 |
Required role |
System Security Officer |
maximum failed logins allows you to set the server-wide maximum number of failed login attempts for logins and roles. For example, to set the system-wide maximum failed logins to 5, enter:
sp_configure "maximum failed logins", 5
Use create role to set maximum failed logins for a specific role or creation. To create the intern_role role with the password “temp244”, and set maximum failed logins for intern_role to 20, enter:
create role intern_role with passwd "temp244", maximum failed logins 20
Use sp_modifylogin to set or change maximum failed logins for an existing login. To change maximum failed logins for the login “joe” to 40, enter:
sp_modifylogin "joe", @option="maximum failed logins", @value="40"
The value parameter is a character datatype;
therefore, quotes are required for numeric values.
To change the overrides for maximum failed logins for all logins to 3, enter:
sp_modifylogin "all overrides", "maximum failed logins", "3"
To remove the overrides for maximum failed logins option for all logins, enter:
sp_modifylogin "all overrides", @option="maximum failed logins", @value="-1"
Use alter role to set or change the maximum failed logins for an existing role. For example, to change the maximum failed logins allowed for physician_role to 5, enter:
alter role physician_role set maximum failed logins 5
To remove the overrides for maximum failed logins for all roles, enter:
alter role "all overrides" set maximum failed logins -1