The following example shows how you can prevent a user from connecting after five failed login attempts.
First, create a login policy lp that has its login policy option max_failed_login_attempts set to the value 5.
CREATE LOGIN POLICY lp max_failed_login_attempts=5;
Create a user John who belongs to the login policy lp.
CREATE USER john IDENTIFIED BY j345 LOGIN POLICY lp;
Because John belongs to lp login policy where max_failed_login_attempts=5, then this user will not be able to log in to the IQ server as soon as he exceeds the limit 5 for max_failed_login_attempts.
