It should be relatively painless, as you could just script out the user, but change the parameters from WITHOUT LOGIN to whatever login you want it to be mapped to.ĮDIT: As pointed out by Aaron below, ensure that you're taking note of permissions and role memberships before making any changes. Remapping can only be done for users that were mapped to Windows or SQL logins.īecause of that, I don't think you can link up a login to this type of user without recreating it.
If you were to create a login and attempt to alter the user with the new login, like the following attempt: create login TestLogin1 By selecting SQL user without login within SSMS' create user dialog, this is the T-SQL that is generated (with no other options besides the user name supplied): USE
0 kommentar(er)
