Auditing is not the purpose of the transaction log. I'm not even sure that the TLog stores the user who execute the change. It's strickly there to support the Atomicity and Durability portions of the ACID properties.

Give SQLAudit a try. I've seen the product. It look good.

-Mike