Why do I need to reset user mapping always after restoring my DB I have created a user using SQL Server 2014 management studio, I have mapped user to a couple of tables as db_owner. But after restoring my databases the mapping again cleared for the user and I need to set the User Mapping. How to fix it?
I found the fix. I need to set my user as sysadmin then it does not get cleared user mappings after a db is restored.