Post reply

Permissions needed to run SQL Profiler

  • June 1, 2007 at 7:10 am

    #62061

    Need to create a role on the db that will be granted to developers whenever they need to use SQL Profiler. I need the permissions that will aloow them to do witthout given them the SYSADMIN role. Any help is greatly appreciated.    

  • June 1, 2007 at 7:31 am

    #710324

    In SQL Server 2000, you need sysadmin privilege to run profiler. The same is not the case with SQL 2005.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • June 1, 2007 at 7:54 am

    #710338

    Hi,

       in 2005 you need to grant ALTER TRACE permissions:-

    grant

    alter trace to {your user here}

    HTH

    Paul

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply