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 Colin 't Hart
Subject Re: Using pgAudit to audit interesting tables for all users except for batch user?
Date
Msg-id CAMon-aSyCvDk924RuP=BU5B4qsFAwJidWzQKmSEMgfL5KXKodQ@mail.gmail.com
Whole thread Raw
In response to Re: Using pgAudit to audit interesting tables for all users except for batch user?  (Greg Sabino Mullane <htamfids@gmail.com>)
List pgsql-general
Tree view
Duh, I feel silly now :-)

Works perfectly.

Many thanks,

Colin

On Tue, 18 Nov 2025 at 16:11, Greg Sabino Mullane <htamfids@gmail.com> wrote:
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: Greg Sabino Mullane
Date:
Subject: Re: Using pgAudit to audit interesting tables for all users except for batch user?
Next
From: Marc Millas
Date:
Subject: Re: postgres in swap space