Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

We're changing domains. I'd like to create a new account for myself, NewDomain\Bob which has the same su-level privileges as OldDomain\Bob, to minimize the chance of disruption when IT flips the switch.

I can easy assign the new login the same database roles. However, I'd like to associate the new login with the same users. Sadly, it seems that a user can have only one login. So what are the alternatives?

I could create the new login with a temporary user, reassign ownership of schemas, drop the old dbo user, and finally rename the new user. However, this would strip some privileges from the old login. In practice this may not matter, but I don't like the idea of cutting off any of my own privs before the new account is available.

The sp_change_users_login sproc looked promising to repoint the dbo user to the new login, but it has some serious limits - like not being usable with Windows logins.

Is there a workaround, or am I perhaps trying to fix the wrong problem?

share|improve this question
2  
This isn't a real solution to your problem, but are ALTER USER DatabaseUserName WITH LOGIN = NewLoginName or ALTER AUTHORIZATION ON DATABASE::DatabaseName TO NewLoginName the sort of statements you're looking for instead of sp_change_users_login? –  Nathan Jolly May 3 '13 at 16:29
    
@NathanJolly: Indeed, if I do need to swap it over rather than testing in parallel, those will make it much simpler. Thanks! –  Jon of All Trades May 3 '13 at 18:48

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.