Dynamics CRM‎ > ‎

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'
Comments