Database Logs

Overview

You can view logs generated from QueryPie’s Database Access Control in Database Logs. You can check information such as DB access permission grants and revocations, DB access history, executed queries, and DML query snapshots. Additionally, you can view and release connection lock history due to DB connection password failures and long-term inactivity through QueryPie.

Related Audit Log Types

In addition to the audit logs commonly provided by QueryPie, when you have a QueryPie Database Access Control (QueryPie DAC) license, the following log types are provided.

1. General

• User Access History : User login and logout history
• Activity Logs : History of resource registration and configuration changes performed by administrators
• Admin Role History : History of administrator permission grants, changes, and revocations

1. Databases

• DB Access History : Connection and disconnection history
• Query Audit : History of completed query executions
• Running Queries : Currently executing queries
• DML Snapshots : Before and after data records when INSERT / UPDATE / DELETE queries are completed (separate configuration required for recording)
• Account Lock History : Connection lock history due to password failures and long-term inactivity
• Access Control Logs : History of connection access permission grants and revocations
• Restricted Data Access Logs : History of access to data restricted by Data Access policies
• Masked Data Access Logs : History of access to data masked by Data Masking policies
• Sensitive Data Access Logs : History of alerts triggered by Sensitive data policies