I'd like to audit all insert, update, delete, AND SELECT activity for a
specific table. I'd also like to capture the username, machine, and SQL
for each transaction.

Oracle's audit feature doesn't provide all the information I
need. However, I found a trigger that can be added to AUD$ to gather more
information, but it still only provides one record for each session (so
inserts, updates, deletes, and selects are combined in a record), and I
can't seem to capture the sql_text (I'm capturing the SQL for the trigger
being executed, and not the SQL of the session that's being audited).

I also tried a trigger on the table being audited but SELECT activity
can't be recorded since it's a trigger.

Does anyone have any other ideas of how to accomplish this?

Thanks,
Laurie

Oracle LazyDBA home page