On 10/30/17 6:48 PM, rakeshkumar464 wrote:
> Is there a way to audit a group like as follows
>
> alter role db_rw set pgaudit.log = 'read,write,function,ddl'
>
> and then any user part of db_rw role can be audited automatically. It does
> not seem to work if I connect to the db as rakesh who is part of db_rw role.
This will not work because settings (GUCs) on a role are not inherited
by roles (or users) that are members of that role. This is a
characteristic of the roles system and not inherent to pgAudit.
--
-David
david(at)pgmasters(dot)net