supa_audit icon indicating copy to clipboard operation
supa_audit copied to clipboard

Create ensure-every-table-have-audit-enabled.sql

Open Forevka opened this issue 10 months ago • 0 comments

What kind of change does this PR introduce?

Feature: added script that will ensure that all tables have enabled audit triggers.

What is the current behavior?

Users should enable audit for each table by hands, this can be tedious if done for systems with tens to hundreds of tables, especially with older/legacy systems.

What is the new behavior?

This script simply traverse over all tables in given schema and applies audit triggers to them in case such triggers are not applied. The script may be executed in dry-run mode, please see comments in the file.

Additional context

I would like to thank the authors and those who helped create supa_audit, you all did great job. I also want to contribute to the development of this wonderful repo

Forevka avatar Feb 15 '25 10:02 Forevka