Share
Report
405Running GP 11.00.1799 (SP2) and MS SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)
Situation:
I have a development (DEV) environment and a production (PROD) environment running *almost* identical setups - on completely separate servers. Obviously there are changes that have been made to the DEV environment that do not exist in the PROD environment, and there are some users in the PROD environment that are not in DEV. Additionally, some user changes have been made (i.e. security, roles and task modifications) in the PROD environment that have not been made in the DEV...and there are some consultant accounts that are setup in DEV but not in PROD.
Basically, my environments do not match 100% of the time which makes restoring fresh data into DEV from PROD painful. What happens is when I restore a backup of PROD onto the DEV database, all of user profiles get hosed and I have to manually go through them and delete them (often times resorting to SQL because GP says I'm unable to delete the user) then set them all back up.
What I'm asking:
Is there any way to setup a user in GP through SQL so I can just blast through the 20 or so users all at once and stop spending hours on a simple data refresh from live to dev?
What I would like to do is the following:
1) Restore fresh data over the DEV database
2) Run DROP USER "uname" from the DEV DB
3) CREATE USER "uname" in the DEV DB granting appropriate rights to the company DB and DYNGROUP
4) Run some SQL statement that will then apply Dynamics security (i.e. user login, user access and user security) to the users
I have referenced KB 878449, but that does not address GP specific security from what I can tell, only master logins.
Am I asking for the absurd?
*This post is locked for comments
All responses (
Answers (
