I am currently working on customizing Alfresco Login page, in that where to find user name and password details of all user's in database.
Depending on the authentication integration scenario for your Alfresco system, it might not actually store passwords for (most) users in the database. Either way, if passwords are stored they are stored in either MD4 or bcrypt hash form. You should never need to interact with this data directly (even when creating a custom login form), as this is what the Alfresco authentication services already provide.
But to answer the question anyway: users are maintained as nodes within the Alfresco database, meaning that their identity and (hashed) passwords are stored via the alf_node / alf_node_properties tables.
Ask for and offer help to other Alfresco Content Services Users and members of the Alfresco team.
Related links:
By using this site, you are agreeing to allow us to collect and use cookies as outlined in Alfresco’s Cookie Statement and Terms of Use (and you have a legitimate interest in Alfresco and our products, authorizing us to contact you in such methods). If you are not ok with these terms, please do not use this website.