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

Поиск
Список
Период
Сортировка

change user passwd

От
Isabella Ghiurea
Дата:
I'm using PG 8.3.4 , what's the method for  remote users to change
their  PG passwd .
Isabella

Re: change user passwd

От
Suresh Borse
Дата:
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
_________________________________________________________________________________________

Re: change user passwd

От
Isabella Ghiurea
Дата:

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


Re: change user passwd

От
Chris Browne
Дата:
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_