Is there a way to log SQL with userid. Is that available through Audit. I ultimately will use this to report on what data columns a user reported on looking for insider mining of our data.
User names are logged in the Audit database. You may need to enable Native Query logging. Even if you do, you won't see the query for reports that fail. It's logged after successful completion. (Same with parameters.)
Try Dynamic SQL settings
https://www.cognoise.com/index.php/topic,36284.msg119581.html#msg119581