ODBC Driver for LDAP

Build 23.0.8790

RemoveMembersFromGroup

Removes users from a group.

Stored Procedure Specific Information

RemoveMembersFromGroup

Removing members from groups with LDAP requires updating the Member field of the Group object with all the UserDNs to be removed from 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:

REMOVE FROM UserDNs#TEMP ([DN]) 
SELECT DN FROM [User] WHERE Id LIKE '%Test%'
EXEC RemoveMembersFromGroup @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 RemoveMembersFromGroup @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 of the Group you want to remove users from. Should be the Id of the Group record.
UserDNs String The UserDNs aggregate or temp table that contains the DN of the users to remove from a Group. Should be the DN of the User record.

Result Set Columns

Name Type Description
Success String Indicates whether members were removed from a group was successfull or not.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8790