How To Make Someone a Microsoft CRM Deployment Manager Using SQL

--Step 1a figure out the user's CRM user id

Open your user record in Microsoft CRM and copy your user id (Ctrl + N),

--Step 1b

SELECT Id, UserId

FROM [MSCRM_CONFIG].[dbo].[SystemUserOrganizations]

WHERE CrmUserId = '7C0EAC14-0284-E111-942D-00155D017404'

--replace '7C0EAC14-0284-E111-942D-00155D017404' with your real user id from step 1a

--Step 2 run update command

INSERT INTO [MSCRM_CONFIG].[dbo].[SystemUserRoles]

([Id], [SecurityRoleId], [SystemUserId], [UniqueifierId], [IsDeleted])

VALUES

('id from above', '19cfbc8d-77ed-459e-9909-1bf1cc1b0430',

'userid from above', NULL, 0)

--Step 3 update another table with the user's windows domain name

update Systemuser set name ='domain\user' where

id='7F0EAC14-0284-E111-942D-00155D017404'