Add a user to server-based MultiTerm termbase

Question

I'm trying to programmatically add a GroupShare user to a server-based MultiTerm termbase - ideally using an API - and assign this user the "Expert" role (or any custom role, for that matter). 
 I've seen the following question in which the proposed solution is to add the user as an administrator via the GroupShare UI: 
 https://community.sdl.com/products-solutions/solutions/customer_experience_cloud/language/language-developers/f/57/t/4380 
 But having added the user via GroupShare and assigned both the "Administrator" and even "Power User" roles (as well as "MultiTerm Guest"), when I download a termbase (as this test user) via the API and then check the access privileges, the user still has only the privileges of a public user. 
 Furthermore, having looked around in the MultiTerm databases, I can see that for the termbase DB in question there are mtUsers, mtUserRoles and mtRoles tables. I've therefore even tried manually editing the test user's mtUserRoles entry to assign the roleId corresponding to "Expert" but still the retrieved termbase says that this user has read-only access. 
 Is there any way possible to programmatically assign and later remove the role of "Expert" to and from a user? 
 In fact, given that I've added "Administrator" and "Power User" roles and the user still has read-only access, is there any way - programmatic or not - to assign a role to a MultiTerm user?

Romulus Crisan (former member) · Answer

For Groupshare 2015 you can add a new user and certain roles by using the Rest API. If go to the following url of your GS instance you will find the actions that are available: http://{your groupshareaddress}/documentation/api. You can work directly with this API or you can use Groupsharekit which is a client library for this API. You can find more details about this library here: 
 To see an example of you can add a user have a look here: 
 
 Also you can find an example on how to add roles to a specific user:

Luis Lopes · Answer

Hi Andrew, 
 
Unfortunately this is not possible through any API yet, it's something we are working on. 
 
Your best bet is directly in SQL currently. Find below a script someone internally created: 
 
USE should be the DB you want to add the user to. 
 
BEGIN TRANSACTION 
 USE MTMaster_1 
 DECLARE @UserID NVARCHAR(256) = 'username'; 
 DECLARE @RoleName NVARCHAR(256) = 'Expert User'; 
 INSERT INTO [dbo].[mtUsers] ([id]) VALUES (@UserID); 
 INSERT INTO [dbo].[mtUserRoles] ([userId], [roleId]) 
 SELECT @UserID, [id] 
 FROM [dbo].[mtRoles] 
 WHERE [name] = @RoleName; 
COMMIT 
 
Thanks, 
Luis

GroupShare Developers > GroupShare Developers forum

Add a user to server-based MultiTerm termbase