Users are not added to the default group

Still need help?

The Atlassian Community is here for you.

Ask the community


Platform Notice: Server and Data Center Only - This article only applies to Atlassian products on the server and data center platforms.

Summary

When setting up a Delegated LDAP directory, or a Read Only with Local Groupswe can define a list of groups that users will automatically be added to when they first log inHowever, 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:

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:
DELETE
FROM cwd_user_attributes
WHERE attribute_name = 'autoGroupsAdded'
AND attribute_value = 'true';
  • Start Jira on each node


Last modified on Sep 13, 2021

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.