Community mailing list archives

Re: how to change user password using psql

Vauxoo S.A. de C.V., Moisés Augusto López Calderón
- 03/23/2015 16:18:30
What SQL standard you are using (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 <>:
alter user username with password 'newpassword';

On Mon, Mar 23, 2015 at 12:42 PM, robert <> wrote:
Hi there,
I would like to change some user password using psql commands:
select login, password, password_crypt from res_users where login = 
        login                  | password | password_crypt
--------------------------+--------------+---------------- |                  |
(1 row)

now I would like to set the password of that user.
How would I do that?

thanks for your help

Post to:

Post to:

Moisés López Calderón
Vauxoo - OpenERP's Gold Partner
Mobile: (+521) 477-752-22-30
Office: (+52) 477-773-33-46
twitter: @vauxoo