where alfresco storing the user details like username, pwd

[mialfresco]

Hi team,
I'm using mysql with alfresco labs 3.0.
I have created a couple of users through explorer. but i didn't found these users in mysql db.
Can anyone tell me where it is storing the user details (user name, password..) and security mechanism.
NOTE: i'm not using any other security mechanisms like ldap, ntlm..etc

thanks in advance.

[cheffilet]

Alfresco 3 Labs Final

SELECT * FROM (select * from alf_node where type_qname_id = 5) users, alf_node_properties properties WHERE users.id = properties.node_id;

‍‍‍‍

[mikeh]

Note, however that's it's a really, really bad idea to access the database directly (except perhaps read-only operations).

Mike

[mialfresco]

Thanks Cheffilet and Mike.

[wmay]

Note, however that's it's a really, really bad idea to access the database directly (except perhaps read-only operations).

Yes but this information where to find the user in the database can be useful - we had the situation (not only one time) during our tests of the CE 3.2 that Alfresco added multiple "dummy" admin users with the same ID "admin" but with multiple and different names and we had no other chance to reset the database. There is no way from the UI to remove or delete such "automatic" added users. Maybe it is possible by direct delete such entries from the database. The real problem is that it is not clear from where such "dummy admins" are added if this happens only one time or each time a certain action is performed and also for each of these users a home folder is created …..

Maybe it can be a way to look to the database and to delete such "ghost users" till the bug is found and fixed.

Does anybody also had such "automatic" added "admin" users - which can not removed via the normal application ?

[mwildam]

And the other important question: If deleting users using SQL with a statement deriving from the one above, are there other links that should be deleted then also?

[cheffilet]

My intention on posting a SQL-Statement was far from using Create, Update or even Delete-Operations. Thats a realy bad idea and i totally aggree with Mike.