Re: Using pgAudit to audit interesting tables for all users except for batch user?

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
>
> --
> Crunchy Data - https://www.crunchydata.com
> Enterprise Postgres Software Products & Tech Support
>
>