problem in updating user details in crowd via database

Hello Team,

We know that updating user details via back end is not recommended. But we have a task to achieve this.

We would like to update the missing user details from crowd database. And to achieve this we are able to update the cwd_user table using query (UPDATE CWD_USER SET LAST_NAME='lastname' , FIRST_NAME='firstname' , EMAIL_ADDRESS='' WHERE USER_NAME ='username' from database. and this is working perfectly fine.

But when we update the user details via database the display name(refer crowd1 screenshot attached highlighted in red) shows the old values even though the table is updated with modified values.

How can we resolve this issue, please suggest.

Only issue is why it is not showing the updated values in under name.(please refer crowd1 screenshot)

refer the before and after updating the values in crowd.(attached screenshots)crowd1.pngbefore_update.pngafter_update.png

1 answer

1 vote
Bruno Vincent Community Champion Jun 09, 2016

Hi @Gsep Support,

I think this has something to do with the attributes' lower values or the timestamp. This worked for me on HSQLDB database:


Still, you should definitely use Crowd REST User Resource instead of direct updates to the database:

I also notice no mention of Crowd being offline while you break the database with SQL.  You need to have it shut down if you're going to hack the database (and be very careful, and have backups)

Bruno Vincent Community Champion Jun 10, 2016

+1 @Nic Brough [Adaptavist]

You're right, I actually did it while Crowd was offline.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published 15 hours ago in Opsgenie

Getting the Most out of Atlassian and Opsgenie Together

We’re excited to invite you to this action-packed webinar where we will demonstrate how to integrate Opsgenie’s powerful alerting and on-call management tools with your entire Atlassian stack. Mar...

19 views 0 0
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you