For Access Management Connector, we will be creating the users and orgunit dynamically. We will also use the Resource Control Display Configuration (RCDC) modification, mentioned earlier in the chapter, for permissions:
The first step is we need to define our orgunit structure as we defined it earlier in our example. For this, we will create a simple table:
Next we will create an SQL Management Agent to bring in this structure. Now, if this data was already present, we could have created a view to dynamically get this OU structure as follows:
SELECT DISTINCT 'TFC' AS OrgUnitID, 'root' AS ParentID FROM [FIMSynchronizationService].dbo.mms_metaverse WITH (NOLOCK) UNION ALL SELECT DISTINCT CONVERT(nvarchar(50), department) AS OrgUnitID, 'TFC' AS ParentID FROM [FIMSynchronizationService].dbo.mms_metaverse WITH (NOLOCK) WHERE employeetype IS NOT NULL UNION ALL SELECT DISTINCT CONVERT(nvarchar(50), employeetype) + '-' + CONVERT(nvarchar(50...