Users are not added to the default group
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
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 Jira stores in the database which user has already been added once to a default group.
Environment
Jira Server or Data Center
Diagnosis
Affected users can be confirmed using the following SQL query:
1
2
3
SELECT * FROM cwd_user_attributes
WHERE attribute_name = 'autoGroupsAdded'
AND attribute_value = 'true';The results include only affected users.
Cause
This is expected behavior if user is a user has been removed from a default group.
Solution
Remember to backup your database before performing any changes.
Stop Jira on all nodes
To have users added to the default groups when they log in once again, run the following query against the Jira database:
1
2
3
4
DELETE
FROM cwd_user_attributes
WHERE attribute_name = 'autoGroupsAdded'
AND attribute_value = 'true';Start Jira on each node
Was this helpful?