SQL Server requires the VIEW SERVER STATE permission
book
Article ID: 52204
calendar_today
Updated On:
Products
Clarity PPM SaaSClarity PPM On Premise
Issue/Introduction
Clarity requires the VIEW SERVER STATE permission with MS SQL. Why is this required?
Environment
Release: All Supported Releases
Resolution
This is "as designed" and required for proper Clarity functionality, as there are areas of the product that require its use. The following are some of the areas that require its use.
cmn_dblocks_sp, which is used for monitoring deadlocking scenarios (this is a diagnostic stored procedure).
Financial GL transaction posting to prevent data corruption due to multiple concurrent executions.
Financial Post to WIP function to prevent data corruption due to multiple concurrent executions.
Clarity configuration code reads this to determine if this permission is set and will log this to the logs if it is not set. This configuration is accessible and available for developers to use for future features.