Orchestrator 2012 Web Console permissions do not reset

Posted: February 28, 2013 in Orchestrator, Solved
Tags: ,

Have found an issue when using the Orchestrator Web Console where the permissions a user has are still active after they have been removed.

Scenario:

  1. Permissions are granted to an AD group to a runbook folder using the Designer console
  2. User is added to the AD group
  3. User can connect to Designer and also the Web Console to see and manage the runbooks in that folder
  4. Remove the user from the group
  5. In Designer, the user no longer has access and cannot see the folder or runbooks
  6. In the Web Console, the permissions are unchanged and the user can still view and manipulate the runbooks

Suggestions provided through a post to the technet forums suggested that the permissions are cached in the SQL database in the “Microsoft.SystemCenter.Orchestrator.Internal.AutorizationCache” table, however this table was already empty

Restarting the Servers, services, logging the user off and on etc made no difference. The permissions still persisted the following day.

Another user suggested this is a known bug and that they resolved it with a call to Microsoft. I can find no other mention/reference of this bug, so a call to Microsoft it is…

SOLUTION

Microsoft have confirmed that there is a stored procedure in the SQL database that is an old one that should have been updated in SP1. Given this installation was a fresh install done using the SP1 media, it would appear the update procedure was not included in SP1 after all.

They have provided me with the updated stored procedure (Microsoft.SystemCenter.Orchestrator.GetSecurityToken) which seems to have fixed the problem. I’m just doing some more testing but it looks good.

  • Microsoft have told me that this technet article is part of the same problem, so you should be able to requet the hotfix using that.
  • If you are in a rush and trust me enough you can download it from here.
  • The original/current stored procedure is here in case you forgot to make a backup first

To backup the current SP (stored procedure)

  1. Open SQL Management Studio
  2. Expand to Database | Programmability | Stored Procedures
  3. Right Click Microsoft.SystemCenter.Orchestrator.GetSecurityToken
  4. Select Script Stored Procedure as | EXECUTE TO | File
  5. Select the location and name for the file. It will be a .sql file that you can open in Notepad to view

To apply the new SP

  1. Right Click the Database
  2. Select New Query
  3. Paste the contents of the Hotfix SP file into the query window
  4. Click Execute
  5. Restart the Orchestrator Web Server

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s