Re: audit table containing Select statements submitted

From: Manlio Perillo <manlio_perillo(at)libero(dot)it>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: audit table containing Select statements submitted
Date: 2006-05-04 07:29:47
Message-ID: 4459AD6B.4010100@libero.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hogan, James F. Jr. ha scritto:
> Can anyone point me in a direction that may help me populate in real
> time a table that holds?
>
> Current_user
> Timestamp
> "The Select Statement Submitted by the User"
>
> I would like to easily determine who viewed what and when they viewed
> it.
>

I think you can easly log who selected a table, but there is no way to
know whitch columns where selected.

I'll try to add this feature to pglog, thanks for the hint.

Regards Manlio Perillo

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Gary Stainburn 2006-05-04 10:01:16 RFC - multi database/application user authentification
Previous Message Joshua D. Drake 2006-05-03 22:34:17 Re: Help on restoration