Forum Discussion

vasantharaidu's avatar
vasantharaidu
New Contributor II
9 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. S...
Data Integration
Workflow
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)