Are there any server-level security concerns I might be missing with granting a login ALTER TRACE on a SQL 2005 instance?

  • I don't care that the login can see anything that's happening on the server
  • They won't be able to actually DO anything that the trace would show, outside of what they already can (unless I'm missing something). All devs pretty much cover each other and have permission to modify db data and code anyway.

The only thing I can come up with is performance degradation from having excessive (too many, too large, etc) traces running, but this is a controllable concern for me and not a show stopper. Pretty much the only things a dev in this scenario should not be able to do are create/drop databases and modify server security (db security is fine, they're all dbo on each user db).

  • pre sql 2000 sp3 it used to be an easy way to get application passwords. profiler doesn't display any textdata with the word 'password ' (& other hot words) since 2000 sp4 :( – Nick Kavadias Oct 19 '09 at 13:31

See this article:



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.