-
Bug
-
Resolution: Unresolved
-
Low (View bug fix roadmap)
-
None
-
6.3.11, 6.4.8, 7.1.0-OD-03, 7.1.0-OD-04, 7.4.0, 9.4.14, 8.20.30
-
6.03
-
37
-
Severity 3 - Minor
-
2
-
NOTE: This bug report is for JIRA Server. Using JIRA Cloud? See the corresponding bug report.
Steps to Reproduce:
- Create a new User with username "ABCDE" via JIRA User Management page.
- After the user created, run these SQL query to check the user details in the database:
select * from cwd_user where lower_user_name = 'abcde'; select * from app_user where lower_user_name = 'abcde';
- The user details will be appearing for both queries.
- Delete the user via JIRA and run the same query.
Expected Results:
The user Row will be deleted from both tables.
Actual Results:
The user data still exist in APP_USER table.
Note:
If the user is not being deleted in the APP_USER table, would it not take any history or issue link if there is another user with the same name created in the future.
- causes
-
-
- Closed
-
- is related to
-
-
- Closed
-
- relates to
-
-
- Closed
-
[JRASERVER-41327] Deleting User is not deleting the User data in the APP_USER table
I figured this was a bug when I saw we have 4000 in the cwd_user table but 9000 in the app_user table.
Can these be cleared down without an issue?
Jira 9.12.5 this affects,
After years of usage, I see that I currently have 1162 users but 2746 entries in app_user, and collisions are starting to be an issue. I wonder if the user key could be re-engineered to use a mapping table (as Confluence does) to avoid this problem?
HI admin1726,
Could you please create a support ticket at https://support.atlassian.com? That way we can provide you with support specific to your circumstances and with higher security. The credentials should be the same as for this site (https://jira.atlassian.com).
Regards,
Oswaldo Hernández.
JIRA Bugmaster.
[Atlassian].
It's a MAJOR bug!
I've deleted the user (due to buggy profile) and can't create another with same name and email - it creates with all "cached" info from an "old" account (such as: previous actions in audit, etc).
...and all this happens in production environment with paid license!
Have you solution, how to delete the user completely? SQL will be preferred.
P.S. I'm using latest Jira 7.0.10 with mysql backend and internal user directory.
Isn't this a potential GDPR issue in the European Union?