You’re offline. This is a read only version of the page.
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.
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
Share
Report
All responses (
Answers (
14,095
