Re: audit trail

Thanks Larry!

I was wondering whether the Statistics Collector in section 10.2 of the
Admin manual might be a way to not only create an audit trail of insert,
update, and delete, but all sql activity and who is doing it. Could the
pg_stat_activity view or the access functions be used for this?  But maybe
this would not create a continuous stream, and activity would be missed?

Alex Pollock
WFSC Data Services District
Database Administration



-----Original Message-----
From: Larry Rosenman [mailto:ler@lerctr.org]
Sent: Thursday, May 22, 2003 2:02 PM
To: Alex.H.Pollock@WellsFargo.COM; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] audit trail


see the thread I had on the SQL list last week.  Joe Conway posted a
WONDERFUL solution
using contrib/dblink.

LER


--On Thursday, May 22, 2003 11:46:24 -0700 Alex.H.Pollock@WellsFargo.COM
wrote:

> Does anyone know of a good way to create a continuous audit trail with no
> gaps within PostgreSQL that can tell who has done what at what time?
>
> Thanks.
>
> Alex Pollock
> WFSC Data Services District
> Database Administration
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>



--
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749