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-05-13 : 08:09:38
|
| Adnan Khan writes "Hello Sir/Madami am working with Clarusoft (Pvt) Ltd. as a Network Administratorit is Software house sir we have some problem with SQL Server, basically it is software house sir/Madam we have 2 database servers and all Databases running on these server and i assign to users Project wise for E.g (one database name is NewWest and it user name: NewWest and Password: N3W35t) when users can log on this database they have no permission that they work on SQL Debugger and Profiler, Sql Debugger and Profiler cannot run on this user please kindly inform me that what's permission assign to this user...Hope Your Favourable Reply!Regards,Adnan Khan Mughal" |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-05-13 : 08:21:52
|
| To run profiler, you have to by part of the System Administrator group.To run SQL Debugger, they have to be granted EXEC access to sp_sdidebug in the master database.You should never grant access to these on production.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
SQL Debbuger and Profiler