Forum Discussion

vasantharaidu's avatar
vasantharaidu
New Contributor II
8 days ago

Need help on the access group of work profile name

Hi Everyone,

Need your support 

I am currently preparing a dashboard to manage user security details in OneStream. As part of this, I need to retrieve and modify Workflow Profile access groups. Specifically, I want to get the Access Group names corresponding to each Workflow Profile (e.g., for Workflow Profile US, the View group is US_View and the Modify group is US_MOD) based on scenario type.

Currently, I am able to retrieve the AccessGroupID, but I am unable to get the group names. Could you please provide guidance or confirm the table/approach I should use to map Workflow Profiles to their Access Group names?

Your assistance will help in correctly setting up the dashboard and managing user security efficiently.

Data Adapter to pick group

Data adapter to pick Workflowprofile and assigned entities.

Thank you in advance for your support.

Data Integration
Workflow

1 Reply

  • MarcusH's avatar
    MarcusH
    Valued Contributor
    2 days ago

    The security group information is held in the Framework database. You can get it using a Data Adapter like this:

    If you change the Method Query to {}, it will return all the security groups. If you are needing this for a dashboard, it might be better to write a Business Rule that creates a single data table with the name of the security group(s) on the same row. You can get the security information using this function:

    Dim secGroups As List(Of Group) = BRApi.Security.Admin.GetGroups(si)