The user doesn't have access to profiler. Will revoking access to trace work even DBCC Traceon? I didn't think you could deny specific DBCC commands?

Thanks

Great, thanks Leo. I'll do some testing with that tomorrow and see what the results are.

I'm hoping we don't experience anything bad, but if I can do...

It's not an ideal situation we are in, but we want to be able to track or watch for any, oh, lets say malicious activity this individual may attempt. ...

Thanks for the replies, that's kind of what I was thinking.

The database group was a relatively new area for my company and as such was set up with an "open"...

Thanks guys, I'll pop into the server and make some adjustments and let you know how it goes.

Thanks again