SQL Server Performance

User Access/Rights for using Profiler

Discussion in 'Performance Tuning for DBAs' started by durgesh, Aug 25, 2005.

  1. durgesh New Member

    What kind of RIGHTS should I give to an user who just wants to see or use the SQL Profiler?

    Thanks in advance.

    Durgesh.
  2. satya Moderator

    With Windows Authentication mode, the user account that runs SQL Profiler must be granted permission to connect to an instance of SQL Server.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. ghemant Moderator

    hi,<br /><br />and if runs on sql authentication mode then :<br /><br />EXEC sp_addlogin 'hemant' -- add login for user hemant<br />EXEC sp_grantdbaccess 'hemant' --grant db access for user hemant<br />EXEC sp_addrole 'sysadmin' -- if sysadmin role is not added<br />EXEC sp_addsrvrolemember 'hemant', 'sysadmin' -- sysadmin is required role in order to enable user to run SQL Profiler<br /><br /><br />[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br />Regards<br /><br /><br /><br />Hemantgiri S. Goswami<br />ghemant@gmail.com<br />"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemant Goswami<br />
  4. durgesh New Member

    Thanks to both Satya and Hemantgiri.

    But my problem is that the user should have only the rights to use profiler and should not be able to use anything else.

    Thanks in advance





    Durgesh.
  5. ghemant Moderator

    hi Durgesh,<br />AFAIK you have to assign "sysadmin" to the user in order to permit him for profiler <br /><br /><br />[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br />Regards<br /><br />Hemantgiri S. Goswami<br />ghemant@gmail.com<br />"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemant Goswami<br />

Share This Page