DATA Step, Macro, Functions and more

User Metadata management using SAS code dynamically

Reply
Contributor
Posts: 31

User Metadata management using SAS code dynamically

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

Super User
Posts: 5,426

Re: User Metadata management using SAS code dynamically

Posted in reply to nikhil_khanolkar

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.

Data never sleeps
Super User
Posts: 5,426

Re: User Metadata management using SAS code dynamically

Contributor
Posts: 31

Re: User Metadata management using SAS code dynamically

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

Super User
Posts: 7,771

Re: User Metadata management using SAS code dynamically

Posted in reply to nikhil_khanolkar

See my answer in your other thread.

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

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Trusted Advisor
Posts: 3,212

Re: User Metadata management using SAS code dynamically

Posted in reply to KurtBremser

Agree kurt missed that other one....

---->-- ja karman --<-----
Trusted Advisor
Posts: 3,212

Re: User Metadata management using SAS code dynamically

Posted in reply to nikhil_khanolkar

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

---->-- ja karman --<-----
Ask a Question
Discussion stats
  • 6 replies
  • 306 views
  • 0 likes
  • 4 in conversation