Profiler Rights
-
I am interested in giving right to developers to use SQL Profiler but without the sysadmin roles ?
I grant exec to some sps (sp_trace_..) but it didn't work ?
Does somebody make that here ?
-
Not possible. You set something up so that you run it via sql agent maybe as a "proxy", but the job would still need sysadmin rights.
Andy
-
This is another one of the new "features" in SQL 2000 that has made the developers life more difficult. We used to love to be able to figure out those really complicated application problems by intercepting the actual SQL call. Now, like many other things, we have to rely on DBA's to do this which means we don't use it anymore.
-
rodalsteve: I share your sentiments, that's why I insist on the developers getting a server of their own, either on their workstation or a shared server, which they have admin rights too.
Once you've developed the app, it goes past me to ensure that site standards have been followed.
Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface
Edited by - phillcart on 09/16/2003 5:51:37 PM
--------------------
Colt 45 - the original point and click interface
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply