DB Access History

Overview

This section records the history of DB connection attempts and disconnections managed by the organization.

Viewing DB Access History

1. Navigate to the Administrator > Audit > Databases > DB Access History menu.

2. Logs are displayed in descending order for the current month.

3. You can search the logs using the search bar at the top left of the table with the following criteria:

   1. Name: User's name

   2. Error Message: Phrase in the access error message

   3. Client IP: User's IP address

4. Click the filter button to the right of the search field to filter logs using AND/OR conditions with the following options:

   

   1. Connection Name: Name of the DB connection

   2. Database Type: Type of the database

   3. Action Type: Whether it was a connect or disconnect attempt

   4. Result: Whether the connection was successful or failed

   5. Action At: Time of the connection attempt

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. No: Event identification number

   2. Action At: Date and time of the DB connection attempt

   3. Action Type: Whether it was a connect or disconnect attempt

   4. Result: Whether the connection was successful or failed

      1. Success

      2. Failure

   5. Name: User's name

   6. Email: User's email

   7. Cloud Provider: Name of the cloud provider

   8. Connection Name: Name of the DB connection

   9. Database Type: Type of the database

   10. Privilege Name: User's access privilege

   11. Client IP: User's client IP address

   12. Replication Type: Type of DB replication

   13. DB Host: Connected DB host

   14. DB User: DB user ID

   15. DB Name: Name of the database

   16. Client Name: Name of the client used (e.g., DataGrip)

   17. Error Message: Records of connection failures or other issues

   18. Connected From: Connection method

Viewing DB Access History Details

Click on any row to view detailed information about the event.

• The drawer on the right displays the following information:

  1. Result: Whether the connection was successful or failed

     1. Success

     2. Failure

  2. Name: User's name

  3. Action At: Time of the connection attempt

  4. Action Type: Whether it was a connect or disconnect attempt

  5. Privilege Name: User's access privilege

  6. Connection Name: Name of the DB connection

  7. Host Name: Name of the host executing the connection

  8. Connected From: Connection method

  9. Client Name: Name of the client used (e.g., DataGrip)

  10. Client IP: User's client IP address

  11. Replication Type: Type of DB replication

  12. Database Type: Type of the database

  13. DB Host: Connected DB host

  14. DB Name: Name of the database

  15. DB User: DB user ID

  16. Error Message: Records of connection failures or other issues