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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
