How to reset the default group membership action of LDAP directories
Summary
When setting up a Delegated LDAP directory, or a Read Only with Local Groups, we can define a list of groups that users will automatically be added to when they first log in.
However, if a user is removed from a default group, it won't be added automatically again. That's because Confluence stores in the database which user has already been added once to a default group.
Environment
Confluence Server or Data Center
Solution
Remember to backup your database before performing any changes.
To have users added to the default groups when they log in once again, run the following query against the Confluence database:
DELETE FROM cwd_user_attribute WHERE attribute_name = 'autoGroupsAdded' AND attribute_value = 'true';
- It may take some time for this change to be reflected in the application due to Confluence Cache Management. If you need this change to take effect immediately, you'll need to Flush Cache Management.
- Go to > General Configuration > Cache Management
- Click on Flush All, at the bottom of the page