How Jira define a unique user and identify a unique user

Question

Dear all,

We are using Jira Data-Center and we have issue with unique users in Jira database.

It seems to me that Jira identify unique users by its user_key and lower_user_name, is it really the case ?

Because sounds to be by doing so we have duplicate user account in database for same user

Thanks for clarification

regards

Fran Garcia_690cr7 · Answer

cwd_user has a field called directory_id, i think jira gives precedence to rows ordering by that directory, I would say even in loging into the app.

something like this

SELECT lower_user_name, directory_id, COUNT(lower_user_name) 
FROM cwd_user
GROUP BY lower_user_name
HAVING COUNT(lower_user_name) > 1

sc_lt8t0d · Answer

My AD directory is define first in the order list from the UI but that does not means that records in cwd_user are in same order..

What type of querry are you thinking about ?

Fran Garcia_690cr7 · Answer

You can define the order of the user directories. I think only the first one would be used in case of a repetition.

Yoou could check if that is happening with a query to cwd_user to get possible duplicates in low_user_name.