Thread: Auditing usage

Auditing usage

From

"Little, Douglas"

Date:

12 May 2010, 21:36:42

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

Douglas.Little@orbitz.com

Attachment

image001.jpg

Re: Auditing usage

From

Richard Broersma

Date:

12 May 2010, 21:48:53

On Wed, May 12, 2010 at 2:36 PM, Little, Douglas <DOUGLAS.LITTLE@orbitz.com> wrote:

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

This is the closed thing I've seen outside of scanning the postgresql logs.

http://www.depesz.com/index.php/2007/09/21/what-fields-are-usually-changed-when-updateing/

--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug