When we restore backups to new server then users in the database are not mapped with their login in the new server
Its because sid is not matching.In this case we will are used to with sp_change_users_login
But this procedure will be deprectated in future version . So instead of this we should use alter user
alter user username
with
= new username,
,
So for mapping a user test with testlogi we will use
ALTER USER test WITH login = testlogin
Its because sid is not matching.In this case we will are used to with sp_change_users_login
But this procedure will be deprectated in future version . So instead of this we should use alter user
alter user username
with
So for mapping a user test with testlogi we will use
ALTER USER test WITH login = testlogin
No comments:
Post a Comment