Turning off MAX_FAILED_LOGIN_ATTEMPTS does not work

Detail name	Value
Changelog Number	7554
Type	Bug
Status	Resolved
Affected Versions	Exasol 6.1.0, Exasol 6.1.1
Fix Versions	Exasol 6.1.2
Resolution Date	2019-02-25

Problem

If you turn MAX_FAILED_LOGIN_ATTEMPTS on , turning it off does not work:

ALTER SYSTEM SET PASSWORD_SECURITY_POLICY= 'MAX_FAILED_LOGIN_ATTEMPTS=2' ;
ALTER SYSTEM SET PASSWORD_SECURITY_POLICY='OFF'; -- has no effect

Workaround

Increase the value so that is doesn't have an effect on your users:

ALTER SYSTEM SET PASSWORD_SECURITY_POLICY= 'MAX_FAILED_LOGIN_ATTEMPTS=100' ;

If that limit is reached reset the users individually:

ALTER USER user1 RESET FAILED LOGIN ATTEMPTS;