Symptoms
Some customers have reported problems with permissions, where some space and/or global permissions have been lost if using a case-sensitive database. The problem arises when the case of the username or group name, as referenced by the permssion, does not match the case of the user's username or the group name.
 | Examples 1. User John Doe has username jdoe but the permission was created for JDOE. In some cases, situations like those above may result in the space permission or global permission being ignored. |
 | This issue should only affect Confluence 3.4.x and earlier. Confluence 3.5 introduced a different user management scheme that is not susceptible to DB case sensitivity. |
Cause
In Confluence 2.7.2 and later:
- The space permissions and global permissions screens will display a message highlighting any case-sensitivity mismatches.
- We have also provided a routine to fix existing permissions affected by the case sensitivity problem, as described below.
Resolution
To run this routine,
- Go to the following location in your browser:
- Read the information on the page, to verify that you do indeed want to run this routine.
- Click 'Proceed' to run the routine.
| What will the routine do? If both the following are true: The username referenced by the permission,
Then the routine will change the permission's username to match the user's username exactly, in terms of upper/lower case. Similarly for group permissions, the routine will change the permission's group name to match the related group name exactly, in terms of upper/lower case. If one or more duplicate permissions exist as a result of this change, the duplicates will remain i.e. the routine will not remove any duplicated permissions. In these rare cases, you may see the following behaviour:
|
