none
Minimal permissions to tune indexes? RRS feed

  • Question

  • Hello a developer requested to have permissions to run SQL Profiler.

    From my understanding user needs to be within sysadmin role or be granted ALTER trace permission which sounds too high to grant.

    What other methods if Profiler is too high permissions can developer use to tune indexes with minimal permissions?

    Thanks in advance.

    Friday, November 8, 2019 5:55 PM

Answers

  • Hello Friend ,

    In this case, you can easily give him the permission he needs only for tracer.
    Here's the link that is very short and simple:

    Permissions Required to Run SQL Server Profiler



    If this answer has helped you, mark it helpful so that someone else with a question or similar problem can find an answer or help more easily. Jefferson Clyton Pereira da Silva - [MCSA | MCP | MCTS | MTA | Database Analyst - Sql Server and Oracle]
    Friday, November 8, 2019 6:19 PM

All replies