Hola Cesar,
Viste este post??
http://forums.alfresco.com/en/viewtopic.php?f=3&t=642
The user passwords are stored as an MD5 password hash as a property off a user type in the system store. So it's in the node_properties table. Why do you need access to those values directly?
Saludos
select n.id, np2.string_value "username", n.uuid, np1.string_value "password" from alf_node n, alf_node_properties np1, alf_node_properties np2 where n.type_qname_id = 5 and n.id = np1.node_id and n.id = np2.node_id and np1.qname_id=10 and np2.qname_id=11;
+—–+———-+————————————–+———————————-+
| id | username | uuid | password |
+—–+———-+————————————–+———————————-+
| 4 | admin | e7486d5f-d576-4e06-bbcd-c6f2d253f4dc | 209c6174da490caeb4ssf3fa5a7ae634 |
| 559 | cesar | d6de1d95-ba64-46cb-b415-2626f6206b21 | a03b5ce62143a41d7c4sd3f20cb37f77 |
+—–+———-+————————————–+———————————-+
Bueno no estaba tan ahi….
select n.id, np2.string_value "username", n.uuid, np1.string_value "password" from alf_node n, alf_node_properties np1, alf_node_properties np2 where n.type_qname_id = 5 and n.id = np1.node_id and n.id = np2.node_id and np1.qname_id=10 and np2.qname_id=11;
+—–+———-+————————————–+———————————-+
| id | username | uuid | password |
+—–+———-+————————————–+———————————-+
| 4 | admin | e7486d5f-d576-4e06-bbcd-c6f2d253f4dc | 209c6174da490caeb4ssf3fa5a7ae634 |
| 559 | cesar | d6de1d95-ba64-46cb-b415-2626f6206b21 | a03b5ce62143a41d7c4sd3f20cb37f77 |
+—–+———-+————————————–+———————————-+
http://forums.alfresco.com/en/viewtopic.php?f=9&t=22817&p=74842
Content from pre 2016 and from language groups that have been closed.
Content is read-only.
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.