Обсуждение: 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:
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_