Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-04-19 : 10:55:14
|
| Jason writes "Select @@Version:Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 3)We have a convoluted departmental structure here. IT is responsible for cross-departmental projects and general infrastructure, but the individual business units are responsible for their own development. So we (IT) do not want the individual departments to have sysadmin rights on a box where they only should have DBO rights in a database or two.I've heard it is possible for non-sysadmins to run profiler. However, MS states ( http://support.microsoft.com/default.aspx?scid=kb;en-us;310175 ) that it is not. I find it hard to believe that MS wouldn't have set something up so that developers could run profiler without granting them sysadmin rights to the whole box.Any ideas on non-sysadmins running profiler?Thanks-Jason" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-19 : 12:33:13
|
| There is no other way to run SQL Profiler. You must have sysadmin privileges on the SQL Server.Tara |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-04-20 : 08:07:12
|
| Grant developers access to any SP in the master database that starts has trace in the name.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-20 : 12:26:42
|
| I've tried that as well, but that didn't work for us here. The only way we could get others to use Profiler was to grant sysadmin, so we only did that on specific instances.Tara |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-04-20 : 23:22:26
|
| ??? Did you grant access to the fn_trace functions as well. That worked for us here.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-21 : 12:24:32
|
| Yes I did. It wasn't until after all of the various grants were given that I noticed that Q article, so I gave up trying since MS documented the behavior that I was seeing.Tara |
|
|
|
|
|
|
Profiler and rights