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(at)lerctr(dot)org]
Sent: Thursday, May 22, 2003 2:02 PM
To: Alex(dot)H(dot)Pollock(at)WellsFargo(dot)COM; pgsql-admin(at)postgresql(dot)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(dot)H(dot)Pollock(at)WellsFargo(dot)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(at)postgresql(dot)org)
>

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