how to copy usermappings from one to another

Hi there drmrdba

Thanks for using QandA platform

You can script out the user mappings from the existing login and apply them to another. In SSMS, right-click the login → Script Login as → CREATE To → New Query Editor Window — this generates the T-SQL with database mappings/roles. Modify the script for the target login and run it. Alternatively, query sys.database_role_members and sys.database_principals to list mappings, then use sp_addrolemember or ALTER ROLE ... ADD MEMBER to reapply them.

If this helps kindly accept the answer thanks much.