We have a table in solidDB (V7) that contains PCI data. Our audit requirement is to track any activity against this table. We need to know who accessed it and the query used. We do not need to know the before and after data, if an update is executed. I've seen a couple of trace options in solidDB, but it appears to be at the database level, not at the table level. We have other tables on this solidDB instance with millions and millions of selects, inserts, deletes, etc. If we turn the trace on at the database level, then we'll track everything and I fear we'll take a huge performance hit. We just need accesses to one specific table.
Any suggestions, anyone?