How to change username

I note that the username is used as the foreign key in the database as the unique user id. So I'm guessing that to change the username would require some ('lengthy') sql? Has anyone done it?

0 votes

1 answers

782 views

ANSWER

You must also update all document properties that refer to this user.
01/28/2012



Hi, From what I know, nobody did this. But if you want to modify a username in sql, the table and column names are easy to understand.

As Benjamin said, you just have to be careful not to forgot any reference to this username. For instance the creator field for the dublincore table.

0 votes



Hi Laurent,

Thanks. I understand what needs to be done, just wondered if someone had already been 'through the pain'. It is not a definite requirement, but if I do need to I will have to share the sql.

Sean

02/06/2012