Skip to content

[BUG] SELECT permission denied for 'syssessions' object in Lite 1.2 version #150

@fabriziocs

Description

@fabriziocs

Environment

  • SQL Server Version:
  • Windows Version:
  • Component: Lite
  • Performance Monitor Version: 1.2

Describe the Bug

The Lite 1.2 version of Performance Monitor returns the following error during execution:

Steps to Reproduce

  1. Create a dedicated user for the Performance Monitor application.
  2. Grant the following permissions to the user: VIEW SERVER STATE and VIEW DATABASE STATE.
  3. Launch Performance Monitor Lite 1.2.

Expected Behavior

The application should work without authorization errors, since the necessary grants have been assigned to the user.

Actual Behavior

The application fails and cannot execute the query related to 'running_jobs'.

Error Messages

running_jobs	FAILING	SQL Error #229: SELECT permission denied for the 'syssessions' object in database 'msdb', schema 'dbo'.

Screenshots

Additional Context

The SQL Server user was created specifically for Performance Monitor and was granted VIEW SERVER STATE and VIEW DATABASE STATE, but access to 'syssessions' is denied.

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions