How To Provide Access On Manage Accounts And Groups In Orchestrator?

News Knowledge Base
,
1

How to provide access on Manage Accounts and Groups in Orchestrator in 2021.10 ?

Issue Description: When accessing Manage Accounts and Groups in Orchestrator in 2021.10, blank page appears.

image (1).png



Manage Accounts and Groups in Orchestrator open as blank page

image.png



Resolution:
Note Before running, take a backup of the Orchestrator Data Base.

  1. Obtain PARTITIONID from

===========================

SELECT [Id]
FROM [identity].[Partitions]
WHERE [Name] = 'TenantName'

  1. Obtain USERID from

===========================

SELECT [Id]
FROM [identity].[AspNetUsers]
WHERE [MasterPartitionId] = 'PARTITIONID'
AND UserName = 'USERNAME'

  1. Obtain GROUPID from

===========================

SELECT [Id]
FROM [identity].[Groups]
WHERE [Name] = 'Administrators'
AND [PartitionId] = 'PARTITIONID'

  1. Insert RoleMapping

===========================

INSERT INTO [identity].[UserGroups] VALUES ( 'USERID', 'GROUPID', 'PARTITIONID')