Re: change user passwd

From: Isabella Ghiurea <isabella(dot)ghiurea(at)nrc-cnrc(dot)gc(dot)ca>
To: s(dot)borse(at)direction(dot)biz
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: change user passwd
Date: 2008-12-02 15:52:04
Message-ID: 493559A4.2020502@nrc-cnrc.gc.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Thank you , yes this works in psql .
Isabella
Suresh Borse wrote:
> How the remote user access the postgres database.
>
> Are they using pgadmin ?? Are they able to connect through psql to
> remote database?
>
> IF yes then try following command
>
> dbname=# /alter user "Username" password 'password'; /
>
> In pgadmin tool we can directly edit the user user properties & change
> the password.
>
>
> On Mon, 2008-12-01 at 12:50 -0800, Isabella Ghiurea wrote:
>> I'm using PG 8.3.4 , what's the method for remote users to change
>> their PG passwd .
>> Isabella
>>
>>
> Thanks & Regards,
>
> Suresh Borse
> (DBA)
> _________________________________________________________________________________________
>
> *DIRECTION SOFTWARE SOLUTIONS*
> 5, Brady Gladys Plaza, 1/447, Senapati Bapat Marg, Lower Parel, Mumbai
> - 400 013
> Tel. : 91 22 66615000 (Ext: 350) Fax : 91 22
> 24911046
> Cell : 91 9422 239338 Site :
> www.direction.biz <http://www.direction.biz/>
> _________________________________________________________________________________________
>
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Daniel Cristian Cruz 2008-12-02 16:02:35 Fwd: Not so simple query and a half million loop
Previous Message Ward Eaton 2008-12-02 14:01:29 PostgreSQL Database freezes during backup then generates drwtsn.exe process