I need to add a new user to the server with the same profile, permissions and roles as another existing user. Is there a script that allows for me to copy / replace one users's id with another?
I scripted out the existing user and discovered they have access to 25+ db's and multiple roles on many of them.
so how do i script the new user into those roles?
asked Jan 13, 2011 at 08:53 AM in Default
If you have the scripts for the existing user, can you not just find+replace with the new user, and then run the edited scripts?
answered Jan 13, 2011 at 09:01 AM
Kev Riley ♦♦