Re: audit table containing Select statements submitted - Mailing list pgsql-admin

From Manlio Perillo
Subject Re: audit table containing Select statements submitted
Date
Msg-id 4459AD6B.4010100@libero.it
Whole thread Raw
In response to audit table containing Select statements submitted  ("Hogan, James F. Jr." <JHogan@seton.org>)
List 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

pgsql-admin by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Help on restoration
Next
From: Gary Stainburn
Date:
Subject: RFC - multi database/application user authentification