Database Logs

Overview

You can view logs related to Database Access Control in the Databases section of QueryPie Audit. This includes information on granted and revoked DB access permissions, DB access history, executed queries, and DML query snapshots. Additionally, you can check and release connection lock records due to password failures or prolonged inactivity.

Related Audit Log Types

In addition to the common audit logs provided by QueryPie, the following log types are available with a QueryPie Database Access Control (DAC) license:

1. General

• User Access History: Records of user logins and logouts.

• Activity Logs: Records of administrator actions such as resource registration and settings changes.

• Admin Role History: Records of administrator role assignments, changes, and revocations.

2. Databases

• DB Access History : Records of database connection and disconnection.

• Query Audit : Records of completed query executions.

• Running Queries : Currently running queries.

• DML Snapshots : Pre- and post-data records for INSERT/UPDATE/DELETE queries (requires additional configuration).

• Account Lock History : Records of connection locks due to password failures or prolonged inactivity.

• Access Control Logs : Records of connection access grants and revocations.