Change the System Administrator Account (Master Data Services)
You can change the user account that is designated as the Master Data Services system administrator.
When you complete this procedure, the former system administrator user account is deleted.
To perform this procedure:
You must add the new administrator's user name to the Master Data Manager Users list. For more information, see Add a User (Master Data Services).
You must have permission to view mdm.tblUser and to execute the mdm.udpSecurityMemberProcessRebuildModel stored procedure in the Master Data Services database. For more information, see Database Object Security (Master Data Services).
To change the administrator account
Open SQL Server Management Studio and connect to the Database Engine instance for your Master Data Services database.
In mdm.tblUser, find the user that will be the new administrator and copy the value in the
Create a new query.
Type the following text, replacing DOMAIN\user_name with the new administrator's user name and SID with the value you copied in step 2.
EXEC [mdm].[udpSecuritySetAdministrator] @UserName='DOMAIN\user_name', @SID = 'SID', @PromoteNonAdmin = 1
Run the query.