Post reply

Grant permission to run sql Profiler and compare schema

  • June 7, 2012 at 9:08 am

    #257298

    I would like to to create a domain group and then add users to it.

    The users need to run sql profiler on specific database the also need to compare schema.

    Can I do this on a database level or does it need to be done on a server level?

    How do I do this.

    Any help is greatly appreciated.

  • June 7, 2012 at 12:41 pm

    #1498360

    To run profiler ALTER TRACE (server level) permission is required

    To compare schema VIEW DEFINITION permission is required

    according to BOL,

    The VIEW DEFINITION permission can be granted on the following levels:

    Server scope

    Database scope

    Schema scope

    Individual entities

  • June 7, 2012 at 1:43 pm

    #1498392

    Permissions Required to Run SQL Server Profiler

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

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

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