Change Username

[isalinas]

Is there away I can update the username on the backend or frontend?  Since, the version of alfresco share 3.2 I am using has a bug with case sensitivty with usernames and site activity.  So i would like to change the usernames on all the accounts to lowercase.  Could you please point to the right table to adjust this at?

Thanks!

[rhannink]

Hello,

We are experiencing the same problem.

You can select all the usernames with:

SELECT anp1.node_id,
        anp1.qname_id,
        anp1.string_value as hash_pass,
        anp2.string_value as user_string
 FROM alf_node_properties anp1
         INNER JOIN alf_qname aq1 ON aq1.id = anp1.qname_id
         INNER JOIN alf_node_properties anp2 ON anp2.node_id = anp1.node_id
         INNER JOIN alf_qname aq2 ON aq2.id = anp2.qname_id
 WHERE aq1.local_name = 'password'
AND aq2.local_name = 'username';‍‍‍‍‍‍‍‍‍‍

But what I don't know is if you can just change the usernames without causing any problems in Alfresco. If you have a solution, please share it with us.

Gr. Remco

[h_tjang]

Hello,

We are also having the same problem. We would like to change the usernames of each users.
Could you share with us if this method of updating the database entry works?


Many thanks..