Which database tables hold the Active Directory User Integration Configuration data (AD group-to-user-group mappings shown in Solution Manager > Security > Users), for scripting bulk updates after a database clone (e.g. re-pointing ~30 group mappings from Production values to Test values)?

Q: Which database tables hold the Active Directory User Integration Configuration data (AD group-to-user-group mappings shown in Solution Manager > Security > Users), for scripting bulk updates after a database clone (e.g. re-pointing ~30 group mappings from Production values to Test values)?

The AD group mapping data specifically lives in AD_GROUP_MAPPING_TAB. Related AD User Integration configuration is spread across several other tables with the same AD_% naming prefix — AD_CONFIG_TAB, AD_USER_GROUP_TAB, and AD_ATTRIBUTE_DEF_TAB among them — findable by searching database objects for names starting with AD_. There's no confirmed built-in export/import mechanism for this whole configuration as a package; scripting direct updates against these tables (particularly AD_GROUP_MAPPING_TAB for the group mappings themselves) is the practical path for a bulk post-clone update.

Answer

The AD group mapping data specifically lives in AD_GROUP_MAPPING_TAB. Related AD User Integration configuration is spread across several other tables with the same AD_% naming prefix — AD_CONFIG_TAB, AD_USER_GROUP_TAB, and AD_ATTRIBUTE_DEF_TAB among them — findable by searching database objects for names starting with AD_. There's no confirmed built-in export/import mechanism for this whole configuration as a package; scripting direct updates against these tables (particularly AD_GROUP_MAPPING_TAB for the group mappings themselves) is the practical path for a bulk post-clone update.

← Browse Security and access questions