topic Generate a list of all roles assigned in SAS RGF in Administration and Deployment

Generate a list of all roles assigned in SAS RGF

StickyRoll — Thu, 22 Dec 2022 01:58:17 GMT

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?

Re: Generate a list of all roles assigned in SAS RGF

SASKiwi — Thu, 22 Dec 2022 22:47:01 GMT

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

Re: Generate a list of all roles assigned in SAS RGF

GyaniBaba — Wed, 28 Dec 2022 09:17:47 GMT

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