-
Notifications
You must be signed in to change notification settings - Fork 25
Closed
Labels
bugSomething isn't workingSomething isn't working
Description
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
- Create a dedicated user for the Performance Monitor application.
- Grant the following permissions to the user: VIEW SERVER STATE and VIEW DATABASE STATE.
- 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.
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
bugSomething isn't workingSomething isn't working