You cannot change SID of the existed users, but you can drop user and recreate them. After this you should update of the user's mapping.

Enter the following two lines and replace myDB with the database name and myUser with the correct user name:

USE myDB
 
EXEC sp_change_users_login 'Auto_Fix', 'myUser'