Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 0813864FDFF for ; Tue, 2 Dec 2008 11:52:35 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 40358-10 for ; Tue, 2 Dec 2008 11:52:31 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from nrccenexf2.nrc.ca (nrccenexf2.nrc.ca [132.246.15.83]) by mail.postgresql.org (Postfix) with ESMTP id C676564FDB3 for ; Tue, 2 Dec 2008 11:52:31 -0400 (AST) Received: from nrccenexf2.nrc.ca ([132.246.15.83]) by nrccenexf2.nrc.ca with Microsoft SMTPSVC(6.0.3790.3959); Tue, 2 Dec 2008 10:52:28 -0500 Received: from [192.168.11.203] ([132.246.15.69]) by nrccenexf2.nrc.ca over TLS secured channel with Microsoft SMTPSVC(6.0.3790.3959); Tue, 2 Dec 2008 10:52:28 -0500 Message-ID: <493559A4.2020502@nrc-cnrc.gc.ca> Date: Tue, 02 Dec 2008 07:52:04 -0800 From: Isabella Ghiurea Reply-To: isabella.ghiurea@nrc-cnrc.gc.ca Organization: CADC -NRC User-Agent: Thunderbird 1.5.0.12 (X11/20070530) MIME-Version: 1.0 To: s.borse@direction.biz CC: pgsql-admin@postgresql.org Subject: Re: change user passwd References: <49344E33.6000900@nrc-cnrc.gc.ca> <1228196949.2250.6.camel@dss-052.dsslp.com> In-Reply-To: <1228196949.2250.6.camel@dss-052.dsslp.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 02 Dec 2008 15:52:28.0550 (UTC) FILETIME=[FA737260:01C95495] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200812/12 X-Sequence-Number: 30845 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 > _________________________________________________________________________________________ > >