Preventing Connection After Failed Login Attempts

This example shows how you can prevent a user from connecting after five failed login attempts.

1. 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;

2. 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.