topic Re: User Metadata management using SAS code dynamically in SAS Programming

User Metadata management using SAS code dynamically

nikhil_khanolkar — Wed, 01 Apr 2015 06:37:22 GMT

Hi,

Can we do the Metadata user management with base SAS code instead of using SAS Management console. In my project we want to edit user permissions on a real time basis.

e.g. adding/removing users in the already created groups in metadata

creating new SAS users in metadata etc.

Any help on this would be appreciated.

Thanks,

Nikhil

Re: User Metadata management using SAS code dynamically

LinusH — Wed, 01 Apr 2015 06:52:25 GMT

Editing metadata in SMC is a real time action...

So describe a bit more what you mean be real time, what is the requirement?

The most straight forward technique to update user/group metadata in the background is to use the %mdu-familly macros.

Re: User Metadata management using SAS code dynamically

LinusH — Wed, 01 Apr 2015 06:55:14 GMT

SAS(R) 9.4 Intelligence Platform: Security Administration Guide, Second Edition

Re: User Metadata management using SAS code dynamically

nikhil_khanolkar — Wed, 01 Apr 2015 07:10:23 GMT

Hi Linus,

Thanks for writing. Business scenario is below.

a) We have a user base out of which metadata permissions for few users might change on a frequent basis. This information would be retrieved and stored in a datasets multiple times in a day.

b) we need to use this information and update the user metadata multiple times in a day using batch job.

I hope this clariifies the problem statement.

Thanks,

Nikhil

Re: User Metadata management using SAS code dynamically

Kurt_Bremser — Wed, 01 Apr 2015 07:13:18 GMT

See my answer in your other thread.

And STOP doing multiple posts about the same question in different communities! It is NOT helpful.

Re: User Metadata management using SAS code dynamically

jakarman — Wed, 01 Apr 2015 07:13:20 GMT

The SMC is just one of the may interfaces doing and capable of doing updates into the metadatabase.
You can write almost anything using your own coding.

- SAS(R) 9.3 Language Interfaces to Metadata (batch steps)
- SAS(R) 9.4 Open Metadata Interface: Reference and Usage, Second Edition

- SAS(R) 9.4 Metadata Model: Reference

Re: User Metadata management using SAS code dynamically

jakarman — Wed, 01 Apr 2015 07:15:29 GMT

Agree kurt missed that other one....