Home > mailing lists

Auditing usage - Mailing list pgsql-general

From	Little, Douglas
Subject	Auditing usage
Date	May 12, 2010 21:36:42
Msg-id	8585BA53443004458E0BAA6134C5A7FB061CA5CF@EGEXCMB01.oww.root.lcl Whole thread Raw
Responses	Re: Auditing usage (Richard Broersma <richard.broersma@gmail.com>)
List	pgsql-general

Hi,

Is there anything in the system that would aid tracking who/how often an object (table/column/function/view) is accessed?

In Teradata we have an accesslog table that record attempted access to an object and if it’s granted or denied. Very important to our sox’s folks.

Thanks

Doug Little

Sr. Data Warehouse Architect | Enterprise Data Management | Orbitz Worldwide

500 W. Madison, Suite 1000 Chicago IL 60661| Office 312.260.2588 | Fax 312.894.5164 | Cell 847-997-5741

From: Tom Lane
Date: 12 May 2010, 19:19:14
Subject: Re: pg_dump custom format across versions

From: Richard Broersma
Date: 12 May 2010, 21:48:53
Subject: Re: Auditing usage