Restore Live to Test Security Transfer

(0) Share

Report

Posted on by Rennecia Barran

Hello and good day, trying to improve a process and hoping someone can assist.

I need a script that I can run after restoring live to test to assist with clearing the invalid security records that are copied over.

This is in relation to a user having access to live and not test. When the restore of live is done to test company, the user is 'given' access to test but it is invalid access.

When i try to give the user access to test in GP, the error message comes up stating - user cannot be added to one or more databases. With this, i have to go to SQL, remove the users from the security folder of the test company.

Does anyone have a script I can use to automate this when a restore of live is being done to test? I am thinking similar to the update company ID script, this script should also be done to fix those orphan logins.

Categories:

Microsoft Dynamics GP

All responses (1)

Answers (0)

Suggested answer

David Musgrave MVP ... 14,012 Most Valuable Professional on at

Like (0)

Report

RE: Restore Live to Test Security Transfer

Hi Ali

GP Power Tools Database Validation can fix all the issues with Test Environments or moving servers and much more.

Install it and activate the free 30 day trial period to have a look.

Regards

David