implementing-database-audit-logging - Database Audit Logging Implementation
Track database changes using triggers, CDC, and application-level logging for compliance
Tags
Updated: 2026-05-28Capabilities
Typical Inputs
Typical Outputs
What this skill does
- create audit table
- create trigger function
- attach table triggers
- partition audit table
- create audit indexes
- configure user context
- setup audit archival
- generate compliance reports
Inputs
- database credentials
- tables to audit
- compliance requirements
- storage volume
- database CLI tools
Outputs
- audit table DDL
- audit trigger function
- trigger attachment scripts
- compliance report queries
- audit log records
- partitioned audit tables
Requirements
- PostgreSQL or MySQL
- database permissions
- psql or mysql CLI