How can I get a listing of SAS.IdentityGroups (used in Row-Level Filtering) for user in Viya?

[rgreen33]

We are in the process of switching to Viya.  I have my Viya environment pulling users and groups (some nested) from Active Directory.  I am using Row-Level Filtering on many of my data sets, based on "... IN ('SUB::SAS.IdentityGroups')".  As an administrator, I would like to have a script that I can run for trouble-shooting that will list, for any given user, their SAS.IdentityGroups...as Viya would see them in the Row-Level Filtering.  Is this possible?  I have searched, hoping that a SAS Studio script that might be usable, but I have not found anything.  Any help on this matter would be greatly appreciated.

[gwootton · Accepted solution]

The REST endpoint https://<viya.example.com>/identities/users/<uid>/memberships?depth=-1 would return a list of the user <uid>'s group memberships.

[rgreen33]

Perfect!  This is exactly what I was looking for!  Thank you @gwootton 

[joeFurbee]

Hi @rgreen33,

Here are a couple of options for working with users and groups in SAS Viya. One option is to use the SAS Viya Admin CLI. Specifically, there is the identities CLI. In addition you can read this thread from the Developers Community with another alternative.

There are also various Community articles and SAS blog posts on the subject. I'll try and track a few of those down once we verify this may fit your need.

Thanks,

Joe

[rgreen33]

Thank you @joeFurbee.  I will check these out too!