Обсуждение: change user passwd

I'm using PG 8.3.4 , what's the method for  remote users to change
their  PG passwd .
Isabella

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 _________________________________________________________________________________________

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/>
> _________________________________________________________________________________________
>
>

isabella.ghiurea@nrc-cnrc.gc.ca (Isabella Ghiurea) writes:
> I'm using PG 8.3.4 , what's the method for remote users to change
> their PG passwd .

The method is to use the "ALTER USER" command.

   <http://www.postgresql.org/docs/8.3/static/sql-alteruser.html>
--
(format nil "~S@~S" "cbbrowne" "acm.org")
http://cbbrowne.com/info/lisp.html
"The classic  Common Lisp defmacro is  like a cook's knife; an elegant
idea which seems dangerous, but which experts use with confidence."
-- Paul Graham, _On Lisp_