pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedchange user passwd
4+ messages / 3 participants
[nested] [flat]
* change user passwd
@ 2008-12-01 20:50 Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
2008-12-02 05:49 ` Re: change user passwd Suresh Borse <s.borse@direction.biz>
2008-12-02 17:12 ` Re: change user passwd Chris Browne <cbbrowne@acm.org>
0 siblings, 2 replies; 4+ messages in thread
From: Isabella Ghiurea @ 2008-12-01 20:50 UTC (permalink / raw)
To: pgsql-admin
I'm using PG 8.3.4 , what's the method for remote users to change
their PG passwd .
Isabella
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: change user passwd
2008-12-01 20:50 change user passwd Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
@ 2008-12-02 05:49 ` Suresh Borse <s.borse@direction.biz>
2008-12-02 15:52 ` Re: change user passwd Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
1 sibling, 1 reply; 4+ messages in thread
From: Suresh Borse @ 2008-12-02 05:49 UTC (permalink / raw)
To: isabella.ghiurea@nrc-cnrc.gc.ca; +Cc: pgsql-admin
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
_________________________________________________________________________________________
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: change user passwd
2008-12-01 20:50 change user passwd Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
2008-12-02 05:49 ` Re: change user passwd Suresh Borse <s.borse@direction.biz>
@ 2008-12-02 15:52 ` Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
0 siblings, 0 replies; 4+ messages in thread
From: Isabella Ghiurea @ 2008-12-02 15:52 UTC (permalink / raw)
To: s.borse@direction.biz; +Cc: 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/;
> _________________________________________________________________________________________
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: change user passwd
2008-12-01 20:50 change user passwd Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
@ 2008-12-02 17:12 ` Chris Browne <cbbrowne@acm.org>
1 sibling, 0 replies; 4+ messages in thread
From: Chris Browne @ 2008-12-02 17:12 UTC (permalink / raw)
To: pgsql-admin
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_
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2008-12-02 17:12 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-12-01 20:50 change user passwd Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
2008-12-02 05:49 ` Suresh Borse <s.borse@direction.biz>
2008-12-02 15:52 ` Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
2008-12-02 17:12 ` Chris Browne <cbbrowne@acm.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox