Hello, On Mon, Aug 07, 2017 at 04:33:21PM -0700, anand086 wrote: > Hi, > > I am postgres newbie. > > We are running Postgres 9.6.3 version and have requirement, where we want to > audit any DML action performed by a user whose has module_dml role granted. > > What would be the best way to do that? I was thinking to write something > like https://wiki.postgresql.org/wiki/Audit_trigger, but I am not sure on > how to integrate "user whose has module_dml role granted" into the function. > > Instead of trigger is there any better way to achieve this? >
Did you try pgaudit extension? https://github.com/pgaudit/pgaudit -- Arthur Zakirov Postgres Professional: http://www.postgrespro.com Russian Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
