Community mailing list archives
Re: how to change user password using psqlby
Numa Extreme Systems, Gustavo Marino
I think you are not asking about Postgresql role password, but the Odoo login password.
I you don't remember your password, you could always reset it, via UI. This is the recommended way.
But as a hack, if you wanna set the password to certain value, you should set on database the field password on res users in clear text, Then you could use this password just once. At the first login it will be encrypted and stored in password_crypt (see module auth_crypt), and the clear text version removed.
2015-03-23 17:22 GMT-03:00 Moises Lopez <email@example.com>:
What SQL standard you are using firstname.lastname@example.org? (alter user username with password... really?)With sql-92 standard is:UPDATE res_users SET password = 'newpassword' WHERE login='username';Or you can use in form view of res.users the wizard change password.2015-03-23 13:58 GMT-06:00 OpenERP Master <email@example.com>:alter user username with password 'newpassword';On Mon, Mar 23, 2015 at 12:42 PM, robert <firstname.lastname@example.org> wrote:Hi there, I would like to change some user password using psql commands: select login, password, password_crypt from res_users where login = 'email@example.com'; login | password | password_crypt --------------------------+--------------+---------------- firstname.lastname@example.org | | (1 row) now I would like to set the password of that user. How would I do that? thanks for your help robert--