topic Change Username in Alfresco Archive

Change Username

isalinas — Sun, 21 Feb 2010 17:19:27 GMT

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 ta

Re: Change Username

rhannink — Thu, 29 Apr 2010 18:14:44 GMT

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

Re: Change Username

h_tjang — Mon, 16 Aug 2010 08:09:18 GMT

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..