topic Re: creating SAS Group in Metadata - programmatically in Administration and Deployment

creating SAS Group in Metadata - programmatically

SSA1 — Tue, 14 Aug 2018 12:20:53 GMT

Hi,

How to create SAS User Group in SMC (9.4) - Programmatically.

Thanks,

Sakthi

Re: creating SAS Group in Metadata - programmatically

alexal — Tue, 14 Aug 2018 12:33:26 GMT

@SSA1,

Check these documents, you have to use a combination of METADATA_NEWOBJ & METADATA_SETASSN functions.

SAS® 9.4 Language Interfaces to Metadata -> METADATA_NEWOBJ Function
https://go.documentation.sas.com/?docsetId=lrmeta&docsetTarget=p0ckrfx4pm9pj7n1x3x4e9ddx4cw.htm&docsetVersion=9.4&locale=en

SAS® 9.4 Language Interfaces to Metadata -> METADATA_SETASSN Function
https://go.documentation.sas.com/?docsetId=lrmeta&docsetTarget=p1pt2ddn2xhmaen1p5whdq58ithh.htm&docsetVersion=9.4&locale=en

Here is a description of type "Group": SAS(R) 9.4 Metadata Model: Reference -> Group
https://support.sas.com/documentation/cdl/en/omamodref/67417/HTML/default/viewer.htm#group.htm

Re: creating SAS Group in Metadata - programmatically

LinusH — Tue, 14 Aug 2018 12:39:22 GMT

What is your use case?

Sometimes it's better wit a data driven approach. Then you could use the %mdu-family of macros, which uses a canonical data model as interface.

https://documentation.sas.com/?docsetId=bisecag&docsetTarget=n0l2hp5m00a1z2n1b598q4pknfih.htm&docsetVersion=9.4&locale=en

Re: creating SAS Group in Metadata - programmatically

SimonDawson — Wed, 15 Aug 2018 12:43:35 GMT

@LinusH mentioned the %mdu* macros.
This is likely going to be the simplest method.

Run %mduextr to extract the current metadata users and groups into canonical tables. Make your modifications to the groups you want in those tables. Then load it back in.
3.

Re: creating SAS Group in Metadata - programmatically

SASKiwi — Wed, 15 Aug 2018 20:07:14 GMT

I would recommend backing up your metadata before you do any changes programmatically, just in case something goes wrong. Is this a learning exercise or is it something you will continue to do regularly? I would only see this as a worthwhile approach if you need to do a lot of metadata changes.

Re: creating SAS Group in Metadata - programmatically

rajdeep — Tue, 10 Dec 2019 11:30:35 GMT

Hi Simon,

Hope you are doing great.

I also wanted to add a specific group for a secured library datasets. I have already created the secure library successfully.

I also ran %mduextr(libref=MD1);

I also got N number of canonical tables, now I am just confused in which of those canonical tables I need to add the specific group.

Like, I need to run an insert into query for any one of that canonical table or what exactly should be taken care of I just wanted to know. Can you please help me if possible taking out few moments of your time!

Because I also want to know suppose I am able to add the group at one point of time, but after that can we give the permissions of read,write or execute programmatically ?? Or for permissions we need to touch the SMC to do that manually!!

Your help will be really appreciated.

Thanks....

Re: creating SAS Group in Metadata - programmatically

rajdeep — Tue, 10 Dec 2019 16:17:01 GMT

Hi SASKiwi,

Can you please help me to add a Group for a secured library datasets programatically?

Your help will be really helpful for me.

I got the GRPMEMS table after running the %mduextr macro and inside that I got grpkeyID and MemkeyID. If I add a new row suppose in that table with a unique grpkeyID and MemkeyID will it be update the meatdata?

I am just wondering how I will find the unique key for new Group and besides to GRPMEMS table what other tables need to be updated.

Please help if possible. Thank in advance.

Re: creating SAS Group in Metadata - programmatically

SASKiwi — Tue, 10 Dec 2019 19:13:59 GMT

@rajdeep - This is not a straightforward process and it takes hours of development and careful testing. If this is a one-off requirement then just do it manually. It is a lot safer and quicker this way.

Re: creating SAS Group in Metadata - programmatically

rajdeep — Tue, 11 Feb 2020 15:28:45 GMT

Hi SASKiwi,

I found a solution to this.

./sas-set-metadata-access -profile "Admin" "/MBL Actual" -grant sas:Read,Write,ReadMetadata,WriteMetadata

./sas-set-metadata-access -profile "Admin" "/System/Secured Libraries/MBL" -grant sas:Read,Write,ReadMetadata,WriteMetadata

Batch Tool: sas-set-metadata-access

You can check the link. I think it's safe to do, because I tried and it's working.

Re: creating SAS Group in Metadata - programmatically

SASKiwi — Tue, 11 Feb 2020 18:57:28 GMT

@rajdeep - Good to see you found a way of doing this. For the level of maintenance we do in metadata I still find SAS Management Console the most efficient way of making changes.