topic Re: SAS metadata - list users/roles and groups in Administration and Deployment

SAS metadata - list users/roles and groups

Filipvdr — Mon, 26 Dec 2016 14:47:04 GMT

Hello all,

I managed to create a list of which users are in which groups/have which roles

I want to make a list now of which roles are in which groups. And if possible, which groups are in another group.

Thanks in advance,

Filip

Re: SAS metadata - list users/roles and groups

SASKiwi — Mon, 26 Dec 2016 21:54:03 GMT

You could save yourself some considerable effort and check out third-party tools:

https://www.metacoda.com/en/2015/07/free-sas-metadata-tools/

Re: SAS metadata - list users/roles and groups

MichelleHomes — Mon, 26 Dec 2016 23:50:14 GMT

Thanks @SASKiwi for mentioning the Metacoda tools.

@Filipvdr if you are after nesting information about Users, Groups and Roles, the Metacoda Security Plug-ins software provide this with the User Reviewer, Group Reviewer and Role Reviewer Plug-ins. These reviewers also have reporting and exporting facilities. @PaulHomes demonstrated these reviewers at a recent SAS User Group for Administrators (SUGA) webinar which you can see the ondemand webinar, slides and Q&A at https://communities.sas.com/t5/SAS-Communities-Library/Q-amp-A-from-quot-SAS-9-4-Metadata-Server-Environment-Virtual/ta-p/318955

Please feel free to contact us if you have any questions and would like a free 30 day evaluation.

Kind Regards,

Michelle

Re: SAS metadata - list users/roles and groups

LinusH — Tue, 27 Dec 2016 16:18:20 GMT

An alternative to the assumed great tools from Metacoda, a programmatic approach could include use of the %mdu macro family, which would fill this (and other related information) to "cannonical tables":

http://support.sas.com/documentation/cdl/en/bisecag/69827/HTML/default/viewer.htm#p1ar98lajfgm4jn1wa1h6e19jjre.htm

Also, there is a security reporting macro documented in a parallel appendix.