AddMembersToGroup
Adds users to a group.
Stored Procedure Specific Information
AddMembersToGroup
Adding members to groups with LDAP requires updating the Member field of the Group object with all the UserDNs to be added to the group. The UserDNs input must be provided as a JSON file.You can provide the UserDNs in either of the following ways:
To add the UserDNs via a temporary table:
INSERT INTO UserDNs#TEMP ([DN]) SELECT DN FROM [User] WHERE Id LIKE '%Test%' EXEC AddMembersToGroup @GroupId = '1|CN=jhbkrb5,OU=Kerberos,OU=TIBCODV,DC=NS3,DC=local', @UserDNs = 'UserDNs#TEMP'
To provide the JSON body of the object-array directly:
EXEC AddMembersToGroup @GroupId = '1|CN=jhbkrb5,OU=Kerberos,OU=TIBCODV,DC=NS3,DC=local', @UserDNs = '[{"DN": "CN=Test3333,DC=NS3,DC=local;CN=Test33,DC=NS3,DC=local"}]'
Input
Name | Type | Description |
GroupId | String | The GroupId that you want to add the users to. Should be the Id of the Group record. |
UserDNs | String | The UserDNs aggregate or temp table that contains the DN of the users to add to the Group. Should be the DN of the User record. |
Result Set Columns
Name | Type | Description |
Success | String | Indicates whether members were added to a group was successfull or not. |