Request a Demo
Home   >   mailing lists

Re: Using pgAudit to audit interesting tables for all users except for batch user? - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: Using pgAudit to audit interesting tables for all users except for batch user?
Date
Msg-id CAKAnmmLRzMWc8qsKzu7uYoCVTm2fvME3+DqeeXcT6v1JCjiRPw@mail.gmail.com
Whole thread Raw
In response to Using pgAudit to audit interesting tables for all users except for batch user?  ("Colin 't Hart" <colinthart@gmail.com>)
Responses Re: Using pgAudit to audit interesting tables for all users except for batch user?
List pgsql-general
Tree view
On Tue, Nov 18, 2025 at 4:18 AM Colin 't Hart <colinthart@gmail.com> wrote:
alter user <batchuser> set pgaudit.log to 'none';

That's close! pgaudit.log deals with session level things, but you want to exclude object-level things. Try:

create role skip_pguadit;
alter user <batchuser> set pgaudit.role = 'skip_pgaudit';


Cheers,
Greg

--
Enterprise Postgres Software Products & Tech Support

pgsql-general by date:

Previous
From: "Colin 't Hart"
Date:
Subject: Using pgAudit to audit interesting tables for all users except for batch user?
Next
From: "Colin 't Hart"
Date:
Subject: Re: Using pgAudit to audit interesting tables for all users except for batch user?