CDC is fine for tracking DATA but what about WHO changed it? I can't even seem to write a join query to show the changes to the data by who?

Back to audit triggers then, unless anyone can enlighten me.

Thanks