Forum Discussion

ukkaapie's avatar
ukkaapie
Copper Contributor
Oct 12, 2023
Solved

SC Orchestrator 2022 web api not showing runbooks

Hi, I have tried all sorts of ways to try and get the web api to show runbooks but no go. Have truncated the table, replaced .net runtimes with different version. The web console shows job data but...
  • ukkaapie's avatar
    ukkaapie
    Oct 12, 2023

    So I did actually find the issue. Run the following 3 commands for the Orchestrator database:

    Taken from the this https://learn.microsoft.com/en-us/answers/questions/1374240/system-center-orchestrator-2022-web-api-and-consol:

    GRANT EXECUTE ON object::[Microsoft.SystemCenter.Orchestrator].[GetSecurityToken] TO [Microsoft.SystemCenter.Orchestrator.Operators]

     

    GRANT SELECT ON object::[Microsoft.SystemCenter.Orchestrator.Internal].[Settings] TO [Microsoft.SystemCenter.Orchestrator.Operators]

     

    GRANT SELECT ON object::[Microsoft.SystemCenter.Orchestrator.Internal].[AuthorizationCache] TO [Microsoft.SystemCenter.Orchestrator.Admins]

ukkaapie's avatar
ukkaapie
Copper Contributor
Oct 12, 2023

So I did actually find the issue. Run the following 3 commands for the Orchestrator database:

Taken from the this https://learn.microsoft.com/en-us/answers/questions/1374240/system-center-orchestrator-2022-web-api-and-consol:

GRANT EXECUTE ON object::[Microsoft.SystemCenter.Orchestrator].[GetSecurityToken] TO [Microsoft.SystemCenter.Orchestrator.Operators]

 

GRANT SELECT ON object::[Microsoft.SystemCenter.Orchestrator.Internal].[Settings] TO [Microsoft.SystemCenter.Orchestrator.Operators]

 

GRANT SELECT ON object::[Microsoft.SystemCenter.Orchestrator.Internal].[AuthorizationCache] TO [Microsoft.SystemCenter.Orchestrator.Admins]

Resources