Bug & Solution // Error The SELECT permission was denied on the object 'v_WindowsServicingStates'
Windows Server 2016
SCCM just upgraded to SCCM CB 1806
When i run the Report "Lifecycle 01A - Computers with a specific software product" and i select "Windows 10, version 1703" it throws an error:
Error The SELECT permission was denied on the object 'v_WindowsServicingStates'
It Works fine if I for example select "Windows 8.1"
I could reproduce it both environments - Test and Live.
smsschm_users had no rights on the view 'v_WindowsServicingStates' for select
set it manually, then it works
I had upgraded vom 1802->1806
I now sent a report as a bug, but since i already fixed it in test an live without a screenshot.
AdminAdam Meltzer (ConfigMgr Product Team) (Software Engineer, System Center Configuration Manager) commented
Is this a regression from a previous release? If so, could you please use the smile button in a console to report it as a bug?