Forum Discussion

vasantharaidu's avatar
vasantharaidu
New Contributor III
2 months ago
Solved

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. S...
Data Integration
Workflow
  • MarcusH's avatar
    MarcusH
    2 months 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)

     

MarcusH's avatar
MarcusH
Valued Contributor
2 months 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)