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
acertain column in a table. In fact, I haven't been able to find a way to log selects to a specific table, just
loggingall queries.
It seems that PostgreSQL can audit INSERT, UPDATE, DELETE, and TRUNCATE through the use of triggers. But SELECT
triggersare 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