search cancel

SQL Server requires the VIEW SERVER STATE permission

book

Article ID: 52204

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity 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.

  1. cmn_dblocks_sp, which is used for monitoring deadlocking scenarios (this is a diagnostic stored procedure).

  2. Financial GL transaction posting to prevent data corruption due to multiple concurrent executions.

  3. Financial Post to WIP function to prevent data corruption due to multiple concurrent executions.

  4. 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.