Community mailing list archives

community@mail.odoo.com

Re: how to change user password using psql

by
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 openerpmaster@gmail.com? (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 <openerpmaster@gmail.com>:
alter user username with password 'newpassword';

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

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

thanks for your help
robert

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe


_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe




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