FAILED_LOGIN_ATTEMPTS reappear for droped users if created user has the same name

Detail name	Value
Changelog Number	7557
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

MAX_FAILED_LOGIN_ATTEMPTS is set and a user is locked due to too many login attempts. If you drop that user and create a new user with the same name, the new user will also be locked.

Workaround

You can manually unlock the new user with

ALTER USER user1 RESET FAILED LOGIN ATTEMPTS;