Alfresco Local User account Rename/update via postgres

Question

is it possible to rename alfresco local user accounts ? is there any way to update the user renaming/update via Postgres sql ? Below code as found to list the users. Kindly share the update query

Thanks

    SELECT n.id,
  n.uuid,
  p1.string_value AS "Username",
  p2.boolean_value AS "Enabled",
  q.local_name AS "Type"
FROM alf_node AS n,
  alf_qname AS q,
  alf_node_properties AS p1,
  alf_node_properties AS p2
WHERE n.type_qname_id=q.id
  AND n.id=p1.node_id
  AND p1.node_id=p2.node_id
  AND p1.string_value!=''
  AND
    ((
      q.local_name='person'
      AND
      p1.qname_id IN (SELECT id FROM alf_qname WHERE local_name='userName')
    ) OR (
      q.local_name='user'
      AND
      p1.qname_id IN (SELECT id FROM alf_qname WHERE local_name='username')
    ))
  AND p2.qname_id IN (SELECT id FROM alf_qname WHERE local_name='enabled')
ORDER BY p1.string_value;
 

Answer 1

Unfortunately, there is no supported way to change the user name in Alfresco. Alfresco uses the user ID as a foreign key in many places. Trying to rename users directly in the database is a bad idea and can lead to many inconsistencies and will cause problems later when you don't even expect it anymore.

It is best to use non-semantic user names, such as a number, to avoid privacy or compliance violations.