X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 860579F9C1D for ; Thu, 4 May 2006 04:28:13 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 65630-08 for ; Thu, 4 May 2006 04:28:07 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp1.libero.it (smtp1.libero.it [193.70.192.51]) by postgresql.org (Postfix) with ESMTP id 1E16F9F9B76 for ; Thu, 4 May 2006 04:28:06 -0300 (ADT) Received: from localhost (172.16.1.8) by smtp1.libero.it (7.0.027-DD01) id 4451544900756A3A for pgsql-admin@postgresql.org; Thu, 4 May 2006 09:28:04 +0200 Received: from smtp2.libero.it ([172.16.1.225]) by localhost (asav9.libero.it [193.70.192.87]) (amavisd-new, port 10024) with ESMTP id 20278-05-7 for ; Thu, 4 May 2006 09:28:04 +0200 (CEST) Received: from [151.37.93.210] (adsl-210-93.37-151.net24.it [151.37.93.210]) by smtp2.libero.it (Postfix) with ESMTP id 24499A8C61 for ; Thu, 4 May 2006 09:28:04 +0200 (MEST) Message-ID: <4459AD6B.4010100@libero.it> Date: Thu, 04 May 2006 05:29:47 -0200 From: Manlio Perillo User-Agent: Mozilla Thunderbird 1.5 (Windows/20051201) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: audit table containing Select statements submitted References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Scanned: with antispam and antivirus automated system at libero.it X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/34 X-Sequence-Number: 21566 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