SQL Direct Update Controls

I work for a medium sized finance company where we have about 10 users (DBA and Database Analysts) who are required to process direct database updates through SQL Query Analyzer in the production environment several times a day. We are currently running a logging application (Lumigent Entegra) on our production servers to store all transactional data. I am wondering if anyone has used similar technology to develop an audit process for their users who have full access to production databases? Specifically, I would like to be able to tie each driect insert, delete or update to a request. Just to make my job more fun, requests can come in the form of a Remedy ARS ticket OR a Siebel Service Request object. THANKS!!!