Обсуждение: PostgreSQL Audit question
Hi
I would like to know if there are any options to do “database audit” pertaining to just ‘Some Users” and “Some Tables” with native capability and/or using plugins?
Thanks
Balaji Doraiswamy
Information Security Engineering
(240 386 4761)
<div class="WordSection1"><p class="MsoNormal"><span style="color:#44546A">Hi,</span><p class="MsoNormal"><span style="color:#44546A"> </span><pclass="MsoNormal"><span lang="EN-US" style="color:#44546A">something like <a href="http://pgaudit.org/">http://pgaudit.org/</a></span><pclass="MsoNormal"><span lang="EN-US" style="color:#44546A"> </span><pclass="MsoNormal"><span lang="EN-US" style="color:#44546A">Regards,</span><p class="MsoNormal"><spanlang="EN-US" style="color:#44546A"> </span><p class="MsoNormal"><span lang="EN-US" style="color:#44546A">Johannes</span><spanlang="EN-US" style="font-size:12.0pt;font-family:"Times New Roman","serif""></span></div>
Thanks Johannes.
I did review this and I believe “object” level audit is possible with pgaudit.
Are there any tools/plugins available for “user” level audit. Say for example I would like to audit only “individual” users and not “application” users? Because application user logging may generate a huge log content.
Best Regards
Balaji Doraiswamy
Information Security Engineering
(240 386 4761)
From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Johannes Lochmann
Sent: Tuesday, November 15, 2016 11:00 AM
To: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] PostgreSQL Audit question
Hi,
something like http://pgaudit.org/[pgaudit.org]
Regards,
Johannes