February 13, 2003 at 3:33 am
We are using SQL 7.0. A user, currently associated with SA, is running 'traces'. We need to remove the SA privilege but the user wants to retain the ability to run Trace.
I don't believe this is possible. Am I correct? If yes, is there a Role or a way of assigning lesser rights than SA that will allow this.
Thanks for your help.
Glen
February 13, 2003 at 5:42 pm
No, you have to be an sa to run Trace (or Profiler) in the SQL Server 7 and 2000.
February 13, 2003 at 7:33 pm
You can give a user EXECUTE rights on sp_sdidebug, an extended stored procedure, and this should allow the user to debug.
This also works on MSDE 2000, but I'm not sure about SQL 2K. I seem to remember a developer friend of mine saying it didn't work properly unless you were an SA in the full engine for SQL 2000.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
February 14, 2003 at 2:21 am
I had to grant EXEC to all extended stored procs commencing with XP_TRACE_....,
in addition to SP_SDIDEBUG.
Thanks for the help.
Glen
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply