topic Re: Get roles and their capabilities from matadata. in Administration and Deployment

Get roles and their capabilities from matadata.

Darek — Thu, 21 Jul 2016 07:51:45 GMT

Hi all

Is there any way to create dataset with list of SAS metadata roles and associated capabilities?

I found how to list users with associated groups. http://support.sas.com/documentation/cdl/en/lrmeta/63180/HTML/default/viewer.htm#p1k9zipe59ha2an1pq34gu143lay.htm

I also found macro %MDUEXTR () which give me a lot of useful information. But there is no info about application actions.

I`m not very familiar with browing metadata tree but i found that capabilities are in ApplicationActions tree.

Re: Get roles and their capabilities from matadata.

RW9 — Thu, 21 Jul 2016 08:32:46 GMT

What softare are you using? This doesn't sound like Base SAS, more like one of the other packages.

Re: Get roles and their capabilities from matadata.

Darek — Thu, 21 Jul 2016 09:20:48 GMT

I want to extract this info from metadata via code in SAS Base, so i put this question here.

Of course I have a lot of SAS apps in my depot:

EG,EM,SAS VA, SAS VS.

Where should I ask this question?

Re: Get roles and their capabilities from matadata.

SASKiwi — Thu, 21 Jul 2016 09:53:55 GMT

Your question is correctly placed in the Administration community as managing metadata is a key Admin responsibility.

Trying to unravel the metadata structure is hard. An alternative approach might be to check out the Metacoda SAS plugins to SAS Management Console:

https://www.metacoda.com/en/products/

Re: Get roles and their capabilities from matadata.

anja — Thu, 21 Jul 2016 14:16:39 GMT

That's what I would go with: MetaCoda. For things like that, these plug-ins are extremely helpful.

I "played" around with it a lot and it is a great complementing option for what SAS security already offers.

Re: Get roles and their capabilities from matadata.

MichelleHomes — Thu, 21 Jul 2016 19:46:53 GMT

Thanks @SASKiwi and @anja for suggesting Metacoda Security Plug-ins.

@Darek, the Role and Capability Reviewers display the information you are after and we provide reports in HTML and CSV format. If you'd like a free 30 day evaluation to try out the software in your own environment, please register for one.

Kind Regards,

Michelle