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@xxxxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
