Community mailing list archives
Re: how to change user password using psqlby
yeah, my mistake, I thought you were asking to reset a postgres user command. I would not recommend updating a user password in the database.
On Mon, Mar 23, 2015 at 7:58 PM, OpenERP Master <firstname.lastname@example.org> wrote:
I dont think it really matters what standard, the command I gave is a valid command and will work for Postgresql. The question was to alter user password not to use one that meets an sql standard.Also, your command updates a users password in the database. My command alters a Postgres user password which is completely different. Additionally, I would hope your passwords were encrypted in which case your sql command would not work.On Mon, Mar 23, 2015 at 3:52 PM, Gustavo Marino <email@example.com> wrote:Robert: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.Regards2015-03-23 17:22 GMT-03:00 Moises Lopez <firstname.lastname@example.org>: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--