Issue Summary

The column value of "local" associated with the table "cwd_group" is not updating.
The "local" column in the cwd_group table of a Jira Data Center instance indicates whether a group is a local Jira group. Specifically, if the value of the "local" column is set to 1, it means the group is considered a local group within Jira. This is important when managing group memberships synchronized with external directories like Active Directory or LDAP.

In this case, the value in the local column is set to 0. Updating the LDAP permissions does not change the local column's value to 1.

Steps to Reproduce

1. Spin up a Jira Software application on any supported version
2. Navigate to > User management > User directories .
3. Create a new LDAP directory by clicking "Add directory"
4. Set the LDAP permissions to "Read Only, with Local Groups" or "Read/Write"
5. Once done, try to add a user to the group.

Expected Results

The user successfully adds to the group.

Actual Results

Adding the user to the group fails with the following exception.

Note: During my testing, I encountered a scenario in which the user addition works irrespective of the value of the "local" group.

Workaround

The workaround is to update the DB column "local" value of the table cwd_group manually from 0 to 1.
Take a valid database backup before proceeding with the database update, as direct database updates are not recommended.