AnsweredAssumed Answered

Delete user in mysql

Question asked by jnjp28 on Sep 14, 2010
Hi,

i have a problem with users in my DB.

So, i have 10 users with person aspect but they are not present in "user/alfrescoUserStore " but only in "workspace/SpacesStore" .

select  distinct(string_value),node_id,qname_id from alf_node_properties where qname_id ='80' and string_value not in (select string_value from alf_node_properties where qname_id='141');


+————–+———+———-+
| string_value | node_id | qname_id |
+————–+———+———-+
| guest        |      26 |       80 |
| System       |   64154 |       80 |
| utijur01     | 2314369 |       80 |
| resjur01     | 2314408 |       80 |
| Servai01     | 2881345 |       80 |
| Lebout01     | 2881346 |       80 |
| Carlie02     | 2881347 |       80 |
| Veverk01     | 2881348 |       80 |
| Sijsma01     | 2881349 |       80 |
| Surpie01     | 2881350 |       80 |
| Servot01     | 2881351 |       80 |
| Desmul01     | 2881352 |       80 |
+————–+———+———-+


I can't delete these users in admin conole. I can modify their informations (fisrstname,lastname, e-mail…) but i can't modify password.

Error in admin console :

The user name does not exist


Can you tell me how to delete this users in mysql.

Best Regards

Outcomes