New AD user recognized as deactivated by confluence

Question

We recently added several new users to our AD and once Confluence synced, two of them were added to Confluence, but the third was listed as deactivated.  The users are all in the same groups and have the exact same settings. This particular user has been active and currently works in our network.  He has no other issues, other than Confluence will not recognize him.  I've restarted the sync to our DC several times and still he is listed as deactivated even though he never has been.  Does anyone have any ideas on how to set him as active?

unknown · Answer

Hi @Thomas Deiler,

please see my attached screenshot. As mentioned before, there is NO option to enable or disable a user in our Confluence instance. Users are synced with our AD, NOT the Confluence Internal Directory.

Thomas Deiler_db00h3 · Answer

Dear @[deleted],

that was brave! Accessing DB directly is risky. At all, did you shut down Confluence, first?

Here a screen shot of what I mean:

So long

Thomas

unknown · Answer

Hi @Thomas Deiler, there is no button to activate / deactivate the user. I have managed to reactivate the user by updating the "active" field in the "cwd_user" table in the Confluence DB. cwd_user
SET active = replace
(active,
'F',
'T')
WHERE
user_name LIKE 'InactiveUser';UPDATE