how to copy usermappings from one to another

Question

how to copy usermappings from one to another

drmrdba 0

how to copy user mappings from one to another for sql server database 2017 EE

mawisec 0 Reputation points

2026-07-04T04:01:46.3733333+00:00

@Azar have you ever verified yourself that what you are telling actually works?

Answer recommended by moderator

0 additional answers

Your answer

mawisec 0 Reputation points

2026-07-04T04:01:46.3733333+00:00

@Azar have you ever verified yourself that what you are telling actually works?

Answer 1

Azar 31,725 MVP Volunteer Moderator

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.

Anonymous

2025-11-04T06:39:02.52+00:00

Hi @drmrdba ,

Could you please let us know if the issue has been resolved? I wanted to check if you had the opportunity to review the information provided by @Azar. If you still require support, please let us know, we are happy to assist you.

Thank you.
Anonymous

2025-11-07T08:57:54.3366667+00:00

Hi @drmrdba ,

We haven’t received an update from you in some time. Could you please let us know if the issue has been resolved? If you still require support, please let us know, we are happy to assist you.

Thank you.