Copy user and securables to new user

[MJV57]

I have a user Proj_Coord for domain users cad\proj_coord. I now am changing domain names and would like to copy the user Proj_Coord in SQL with all its attributes and securables to a new user Proj_CoordSTDWI for domain users stdwi\proj_coord. Can anyone help me with this task

 

[NoCoolHandle]

is this a user that maps to a windows or sqlserver login?

 

[MJV57]

sqlserver login

 

[NoCoolHandle]

there is a [blue]sp_change_users_login[/blue] that should give you what you want.

Interestingly it really is designed to work with SQL logins so you are lucky

Rob

http://msdn.microsoft.com/en-us/library/ms174378.aspx