Select Column Auditing/Logging

From: Jeremy Brown <jwbrown77(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Select Column Auditing/Logging
Date: 2009-07-22 19:04:40
Message-ID: 622698.22770.qm@web110703.mail.gq1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hello,

I've tried searching around the net for a feature that would allow me to audit to a table or log select queries against a certain column in a table. In fact, I haven't been able to find a way to log selects to a specific table, just logging all queries.

It seems that PostgreSQL can audit INSERT, UPDATE, DELETE, and TRUNCATE through the use of triggers. But SELECT triggers are unsupported (it does suggest perhaps using RULES).

Has anyone attempted to implement conditional select based logging, even through RULES? I think Oracle has a feature called "Fine Grained Auditing" that has a ton of features that I don't really need, just what's described above in particular.

P.S. The log would just need the user, time, and query.

TIA,

Jeremy Brown

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andy Colson 2009-07-22 19:26:50 Re: Best way to import data in postgresl (not "COPY")
Previous Message Jeff Davis 2009-07-22 18:49:46 Re: Can LIKE under utf8 use INDEXes?