audit table containing Select statements submitted

From: "Hogan, James F(dot) Jr(dot)" <JHogan(at)seton(dot)org>
To: <pgsql-sql(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org>
Subject: audit table containing Select statements submitted
Date: 2006-05-04 17:45:59
Message-ID: D73D467FE58F004E9D3FA25414945DC104FE0715@AUSEX3VS1.seton.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

No response from the pgsql-admin list so I though I would try cross
posting here:
pgsql-sql(at)postgresql(dot)org
pgsql-general(at)postgresql(dot)org

I just know I am not the first to try and do this

Jim

*********************
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 have considered the fact that the result from SELECT yesterday may be
different than the result set returned by the SAME SELECT statement
today, but when used in conjunction with the INSERT, UPDATE, DELETE
audit logging I have already created, the answers to who viewed, what
and when would be readily available.

I have been searching all morning and...

The only thing I find on logging of Select statements is that the
information can be held in the Log Files...if Logging is enabled.

As I am only interested in the statements presented against certain
tables...

Turning on logging gives me more than I need or care to look through.

I could write a script to parses the Log Files into a Database Table but
would prefer to avoid enabling the file logging of statements if
possible.

Thanks for any reference or help you may be able to provide.

Jim

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ben K. 2006-05-04 17:55:56 Re: [SQL] audit table containing Select statements submitted
Previous Message Sebastian Wagner 2006-05-04 17:18:51 Googles sommer of Code 2005 - Postgres Project Proposal - where to discuss? who is responsible? who can mentor?

Browse pgsql-sql by date

  From Date Subject
Next Message Catalin Pitis 2006-05-04 17:52:29 Connecting to Postgres from other machines (outside localhost)
Previous Message Fay Du 2006-05-04 15:31:04 How can I read display message from a C function