Postgres Pro
Downloads
Home   >   mailing lists

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

From Jim C. Nasby
Subject Re: audit table containing Select statements submitted
Date
Msg-id 20060515160240.GQ26212@pervasive.com
Whole thread Raw
In response to Re: audit table containing Select statements submitted  ("Hogan, James F. Jr." <JHogan@seton.org>)
Responses Re: audit table containing Select statements submitted
List pgsql-hackers
Tree view 
On Mon, May 15, 2006 at 10:55:43AM -0500, Hogan, James F. Jr. wrote:
> Only specific tables.
> 
> Of the 150 plus existing there are only 8 or 10 that hold sensitive
> data.

In that case I'd definately go with the suggestion of creating access
functions and logging to a table from within them. Just make sure to
mark the functions as volatile.
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

pgsql-hackers by date:

Previous
From: "Hogan, James F. Jr."
Date:
Subject: Re: audit table containing Select statements submitted
Next
From: Douglas McNaught
Date:
Subject: Re: audit table containing Select statements submitted