The real question is: do you really want to do something like that? Or are there better ways (like pushing the data to another server and having them run their queries/updates/truncates there, then restricting their access in Prod).
The Brent Ozar team had a good talk about this in one of their Office Hours Podcasts.
Basically, the answer was something like:
Imagine your boss asked you to log everything you did during the day at the office on a post-it note.
9:00 AM - Me - Sat at my desk
9:01 AM - Me - Turned my computer on
9:02 AM - Me - Checked my email
9:03 AM - Me - Opened SSMS
The time you'd take to do things (and your overall productivity) would go down the drain.
So be prepared for SQL Server to slow down, since it has to take an extra step and log every query it runs to a table.