This tutorial discusses how to log the changes to a table that you want to monitor into an audit table.

This story continues at http://www.databasejournal.com/news/article.php/3674926