Table Containing username and password

[khinendra]

Hi,

I want to know that in which table alfresco maintains username and password.
If any one knows please reply? I checked many tables but nowhere found it.

[mrogers]

There isn't one.   

There is a person node (which corresponds to your username) and an authentication node (which contains the encrypted password hash (or whatever the internal implementation is).

However the authentication mechanism is configurable so you could use an external authentication system which is based on a user, password table.    Most application servers tend to come with one, which you use for development until you bolt into a real authentication system.

[khinendra]

Hi,
Thanks for reply.

Where can I find these person and authentication node?

[renjithnalinam]

Hi,

Any of you found where the Alfresco storing the user name and passwords/ where I can find the  person and authentication node?

Thanks

[joe_l3]

The md4 hashed passwords and the user's name are stored in the alf_node_properties table. Try this:

SELECT anp1.node_id,
       anp1.qname_id,
       anp1.string_value as hash_pass,
       anp2.string_value as user_string
FROM alf_node_properties anp1
        INNER JOIN alf_qname aq1            ON aq1.id       = anp1.qname_id
        INNER JOIN alf_node_properties anp2 ON anp2.node_id = anp1.node_id
        INNER JOIN alf_qname aq2            ON aq2.id       = anp2.qname_id
 WHERE aq1.local_name    = 'password'
 AND aq2.local_name    = 'username';‍‍‍‍‍‍‍‍‍‍

[renjithnalinam]

Thanks Joe

[joe_l3]

Thanks Joe

😎