Account Lock History

Overview

QueryPie displays connection lock history due to password failures and prolonged inactivity for each user. All failed connection attempts, such as incorrect password entries or attempts from unauthorized IPs, are counted. When the failed attempts reach the threshold set by the administrator, the connection account is locked.

Viewing Account Lock History

1. Navigate to the Administrator > Audit > Databases > Account Lock History menu.

2. Logs are displayed in descending order of occurrence.

3. You can search the logs using the search bar at the top left of the table by the user's name.

4. Click the filter button to the right of the search field to filter logs by Action At (date range) and the following options:

   

   1. Connection Name: Name of the DB connection

   2. Database Type: Type of the database

   3. Lock Status: Type of lock event

      1. Locked: Account lock event

      2. Unlocked: Account unlock event

   4. Action At: Date and time of the event

5. Click the refresh button at the top right of the table to update the log list.

6. The table provides the following column information:

   1. Name: User's name

   2. Email: User's email

   3. Connection Name: Name of the DB connection

   4. Database Type: Type of the database

   5. Attempted Count: Number of connection attempts

   6. Lock Status: Lock status

   7. Unlocked By: Information of the person who unlocked the account

   8. Unlocked At: Date and time when the account was unlocked

   9. Locked At: Date and time when the account was locked

   10. Action At: Date and time of the event

   11. Host Name: Name of the host where the connection was attempted

   12. Client IP: User's client IP address

   13. Replication Type: Type of DB replication

   14. DB Host: Host of the connected DB

   15. DB Name: Name of the database

Unlocking a User Connection Account

1. Navigate to the Administrator > Audit > Databases > Account Lock History menu.

2. Click the checkbox next to the target DB connection of the user whose account you want to unlock.

3. Click the Unlock button at the top right to unlock the account.