We are running SQL Check and would like to use a dedicated SQL user that are not “SA”.
What type of permission is needed to run SQL Check?
SQL check primarily leverages the SQL Server native DMVs to gather performance information. If you give a user enough access to ‘master’ and to “VIEW SERVER STATE” to get values from those views, we should be able to return the metrics that populate to the console.
It worked indeed, thank you very much also quick response
Perhaps adding the suggested solution to main forum so others can see how to do it.
In the thread community.idera.com/.../, it says that the SQLCheck user must be a Windows Administrator. Presumably, that is in addition to having the permissions mentioned in the 1/19/15 post (above) within the SQL Server instances.
Can you quantify what specific permissions are needed to run SQL check? Our DBAs won’t grant SA privileges to anyone, but if we can request what specific rights/procedures we need access to they can usually work with us.
VIEW SERVER STATE permission to get performance metrics (sysprocesses and sysperfinfo)
Member of the sysadmin fixed server role to get related SQL being executed by a Process (DBCC inputbuffer).