Change Username

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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