supa_audit
supa_audit copied to clipboard
Create ensure-every-table-have-audit-enabled.sql
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