Moving logins 1

[thamms]

Hi,

Let's say you have Database "Joe", that has 10 users mapped to it.

Now, let's say you have Database "Fred" on another server, and you want to set up the same 10 "Joe" users in "Fred," with the same exact permissions as they have on "Joe."

Is there a simple way to do this without having to manually recreate the users in "Fred"?

Thanks

 

[mrdenny]

This thread has some code which will allow you to script the rights between the two databases.

thread962-1324602

You will need to create the users manually.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog