Data Access Audit

Overview

The Data Access Audit tab provides a detailed trail of all actions performed within the Data Access module. It helps track changes across users, roles, permissions, and associated metadata objects. The audit log captures who performed an action, what was changed, when it happened, and the source of the change.

Audit entries support visibility and traceability, enabling compliance monitoring and operational transparency across the entire data access lifecycle.

The audit data appears across various levels, including instance, connector, users, groups, and permission entities (database, schema, and table).

Instance-Level Audit

  • Date: Timestamp of the action

  • Audit User: The User who performed the action

  • Action: Performed action (e.g., Add, Edit, Delete)

  • Description: Summary of the change

Connector-Level Audit

  • Date: Timestamp of the action

  • Audit User: The User who performed the action

  • Connection Name: Name of the connector involved

  • Action: Performed action

  • Description: Summary of the change

Azure Entra Users-Level Audit

  • Date: Timestamp of the action

  • Azure Entra User: Affected user from Azure Active Directory

  • Audit User: The User who performed the action

  • Action: Performed action

  • Source: Origin of the change

  • Description: Summary of the change

Azure Entra Groups-Level Audit

  • Date: Timestamp of the action

  • Azure Entra Group: Affected group from Azure Active Directory

  • Audit User: The User who performed the action

  • Action: Performed action

  • Source: Origin of the change

  • Description: Summary of the change

Database Roles-Level Audit

  • Date: Timestamp of the action

  • Database Role: Name of the role affected

  • Audit User: The User who performed the action

  • Action: Performed action

  • Source: Origin of the change

  • Description: Summary of the change

Database Users-Level Audit

  • Date: Timestamp of the action

  • Database Users: Name of the user affected

  • Audit User: The User who performed the action

  • Action: Performed action

  • Source: Origin of the change

  • Description: Summary of the change

Database Permissions-Level Audit

  • Date: Timestamp of the action

  • Connector: The Connector associated with the action

  • Database: Name of the database affected

  • Roles/Users: Role or user impacted

  • Privileges: Type of permission granted or revoked

  • Audit User: The User who performed the action

  • Action: Performed action

  • Source: Origin of the change

  • Description: Summary of the change

Schema Permissions-Level Audit

  • Date: Timestamp of the action

  • Connector: The Connector associated with the action

  • Schema: Name of the schema affected

  • Roles/Users: Role or user impacted

  • Privileges: Type of permission granted or revoked

  • Audit User: The User who performed the action

  • Action: Performed action

  • Source: Origin of the change

  • Description: Summary of the change

Table Permissions-Level Audit

  • Date: Timestamp of the action

  • Connector: The Connector associated with the action

  • Schema: Name of the schema containing the table

  • Table: Name of the affected table

  • Roles/Users: Role or user impacted

  • Privileges: Type of permission granted or revoked

  • Audit User: The User who performed the action

  • Action: Performed action

  • Source: Origin of the change

  • Description: Summary of the change


Copyright © 2025, OvalEdge LLC, Peachtree Corners GA USA

Last updated

Was this helpful?