Re: Enable DB level audit trail

From: GF <phabriz(at)gmail(dot)com>
To: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Enable DB level audit trail
Date: 2024-04-16 18:11:28
Message-ID: CAFePLY3W=3L-NHhsk90mmBcMVB23c4KvuHSDo_E7Lv+vYZSXug@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Il mar 16 apr 2024, 20:01 Ron Johnson <ronljohnsonjr(at)gmail(dot)com> ha scritto:

"Audit tables" are tables just like any other table, which means they can
be changed by anyone with a superuser ROLE.

... and trigger-based audit interferes with the transaction: think of an
exception while auditing, it would rollback also the statement(s) it was
tracking.

giovanni

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Wetmore, Matthew (CTR) 2024-04-16 18:23:23 Enable DB level audit trail
Previous Message Ron Johnson 2024-04-16 18:01:03 Re: Enable DB level audit trail