topic Re: How to search and change multiple user accounts in Administration and Deployment

How to search and change multiple user accounts

Allan_dk — Wed, 09 Jul 2014 10:14:30 GMT

My it-department have changed the domain from ipaep to koncern.

That means that I have to change it for all useraccounts in the User Manager, and that will take some time.

User/Account/Userid = ipaep\abc must be changed to koncern\abc.

How can I make a search and replace for all the user accounts?

Re: How to search and change multiple user accounts

jakarman — Wed, 09 Jul 2014 17:38:22 GMT

check bisecag if it SAS related. SAS(R) 9.4 Intelligence Platform: Security Administration Guide, Second Edition
What is your SAS connection in this?

Re: How to search and change multiple user accounts

kkhelif — Thu, 02 Oct 2014 15:19:45 GMT

Allan,

If you ever used the AD Import for SAS. Make your change through that script and you're good to go.

Thanks

Re: How to search and change multiple user accounts

ouelletpatrick — Thu, 02 Oct 2014 16:01:14 GMT

Hi Allan,

I'm working on something that relates to your goal.

You could do it like this:

1. Run %mduextr to extract information from the Metadata Server and output to a MASTER library (new library):

%mduextr(libref=MASTER);

2. Modify the UserID column of the MASTER.LOGINS table with the info you need.

3. Run %mduextr again and output to a TARGET library (new library). This will be your current unmodified SAS Metadata library

%mduextr(libref=TARGET);

4. Run %MDUCMP to compare your MASTER (with changes) to your TARGET (unmodified) data. This will generates tables representing the changes that needs to be made to the metadata. You'll need a CHANGE library (new library).

%mducmp (MASTER=MASTER, TARGET=TARGET, CHANGE=CHANGE, EXTERNONLY=0);

5. Run %MDUCHGV to check if any changes introduce integrity problems.

%MDUCHGV (TARGET=TARGET, CHANGE,CHANGE, ERRORSDS=name);

When everything checks out, and you've done many, many tests (this is crucial metadata after all!), final step:

6. Run %MDUCHGLB to load the changes and update the metadata

%MDUCHGLB(CHANGE=CHANGE);

SAS Support has a lot of info on these macros.

Good luck!