Generate a list of all roles assigned in SAS RGF

[StickyRoll]

Hi All,

I am using SAS Risk Governance Framework (SAS RGF) and that I would like to have a full list of all roles assigned for all users. In SAS Management Console, the only way to have such a list is by writing base SAS programming. What about SAS RGF? is there an automated generated function to retrieve this list? Otherwise, how can i achieve this?

[SASKiwi]

This is a specialist issue so I think you would be better off opening a Tech Support for it.

[GyaniBaba]

Can you share me your base sas code to extract direct/indirect roles from smc

Suppose
userA is the of groupA, roleZ, groupC and
groupA is part of roleP, groupD

groupD is part of groupF
groupF is part of roleM

groupC is part of roleX

Final output should be
userA roleZ
userA roleP
userA roleM
userA roleX


I can help with your original question as well today, I think rgf roles should be in some postgres table, just need to figure it out