Dynamics CRM Users

NOTE: The information in this article is not from an official Microsoft source. It is the result of my own research. I have not conclusively verified any of the content. The article is for reference only.

Organizations are stored in MSCRM_CONFIG.dbo.Organization

Tables in MSCRM_CONFIG

TableNotes
SystemUserAny user that has been added to any organization in the deployment.
SystemUserRolesHas an entry for each users that is currently a deployment administrator. Links to the SecurityRole table with SecurityRoleId
SystemUserAuthenticationAny user that has been added to any organization in the deployment.
SystemUserOrganizationsHas an entry for each user/organization combination. Users are referenced by UserId (in SystemUserAuthentication) and CRMUserId (in each org db?)

SystemUser table

ColumnNotes
DefaultOrganizationIdThe value is 00000000-0000-0000-0000-000000000000 for users that are deployment administrators
IdUnique identifier for the table
NameSeems to be null except for deployment administrators

SystemUserAuthentication table

ColumnNotes
AuthinfoSID for Windows Account
IdUnique identifier for table
UserIDLinks to SystemUser, SystemUserOrganizations

Use wmic useraccount get name, sid at the command prompt to retrieve SIDs

Tables in Org_MSCRM

TableNotes
SystemUserBaseAny user that has been added to any organization. The SystemUserId column maps to CRMUserId in MSCRM_CONFIG.dbo.SystemUserOrganizations. Curiously there is a field named ActiveDirectoryGuid (MSCRMCONFIG.dbo.SystemUserAuthentication has SID details)

Add Multiple Users

Select Authentication Provider

  • Active Directory
  • Federated Identity Provider

Leave a Comment

Your email address will not be published.