We were facing below error while trying to grant access to the database for specific login.

Problem Description:

Create failed for User (Microsoft.SqlServer.Smo)
SQL Server Error User, group, or role already exists in the current database. (Microsoft SQL Server, Error: 15023)

Solution:

use database name
go
exec sp_change_users_login "Auto_Fix", "user_name"
go