I'm far from an expert with CDC, but as far as I've found out, you cannot use CDC to track who made the change. With insert and update, you can create a workaround by adding a column LastChangedBy and have your system update that column with whoever made the change. Then you'll keep track of each change to a row by following the changes with CDC. With deletes, that workaround won't help you. In other words - CDC isn't there to help you with tracking who made a change to the data. The workarounds aren't complete. So you're probably better off tracking these changes on your own, using triggers or whatever technique you choose.