Обсуждение: PostgreSQL Audit question

Поиск
Список
Период
Сортировка

PostgreSQL Audit question

От
"Doraiswamy, Balaji"
Дата:

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)

 

Confidentiality Notice:: This email, including attachments, may include non-public, proprietary, confidential or legally privileged information. If you are not an intended recipient or an authorized agent of an intended recipient, you are hereby notified that any dissemination, distribution or copying of the information contained in or transmitted with this e-mail is unauthorized and strictly prohibited. If you have received this email in error, please notify the sender by replying to this message and permanently delete this e-mail, its attachments, and any copies of it immediately. You should not retain, copy or use this e-mail or any attachment for any purpose, nor disclose all or any part of the contents to any other person. Thank you.

Re: PostgreSQL Audit question

От
Johannes Lochmann
Дата:
<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>

Re: PostgreSQL Audit question

От
"Doraiswamy, Balaji"
Дата:

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

Confidentiality Notice:: This email, including attachments, may include non-public, proprietary, confidential or legally privileged information. If you are not an intended recipient or an authorized agent of an intended recipient, you are hereby notified that any dissemination, distribution or copying of the information contained in or transmitted with this e-mail is unauthorized and strictly prohibited. If you have received this email in error, please notify the sender by replying to this message and permanently delete this e-mail, its attachments, and any copies of it immediately. You should not retain, copy or use this e-mail or any attachment for any purpose, nor disclose all or any part of the contents to any other person. Thank you.