Post reply

Privileges to run a trace

  • October 1, 2007 at 9:21 am

    #125866

    Is there any way I can give a user read only access to the database, yet have privilges to run a trace.

    Any suggestions and inputs would help

    Thanks

  • October 1, 2007 at 9:43 am

    #737763

    Connect to the instance via Management Studio, right-click the server, select properties, permissions. If my memory serves me correctly you will need alter trace, and view server state.

    Tommy

    Follow @sqlscribe

  • October 1, 2007 at 10:29 am

    #737787

    GRANT ALTER TRACE TO [loginname]

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

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