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

Search Discussions

  • Suresh Borse at Dec 2, 2008 at 6:04 am
    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
    _________________________________________________________________________________________
  • Isabella Ghiurea at Dec 2, 2008 at 3:52 pm
    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/>
    _________________________________________________________________________________________
  • Chris Browne at Dec 2, 2008 at 5:12 pm

    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_

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-admin @
categoriespostgresql
postedDec 1, '08 at 8:51p
activeDec 2, '08 at 5:12p
posts4
users3
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2022 Grokbase