[GENERAL] Audit based on role - Mailing list pgsql-general

From anand086
Subject [GENERAL] Audit based on role
Date
Msg-id 1502148801920-5976507.post@n3.nabble.com
Whole thread Raw
Responses Re: [GENERAL] Audit based on role  (John R Pierce <pierce@hogranch.com>)
Re: [GENERAL] Audit based on role  (pinker <pinker@onet.eu>)
Re: [GENERAL] Audit based on role  (Arthur Zakirov <a.zakirov@postgrespro.ru>)
List pgsql-general
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?

Regards,
Anand





--
View this message in context: http://www.postgresql-archive.org/Audit-based-on-role-tp5976507.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: [GENERAL] Redacting JSONB
Next
From: Venkat Ramkrishna
Date:
Subject: [GENERAL] Ora2pg estimation accuracy