After a migration of a database, the mapping of username is lost.
You can rejoin the username in database security with the “real” username with this commands:

EXEC sp_change_users_login 'Auto_Fix' , 'TheUserName';