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:
Read the rest