Modifying users password in pg_shadow from php

[Együd Csaba]

Hi All,
I'm wonder if there is any possibility to modify a users password by
updating the pg_shadow table.
I'd like to ensure that when the user modifies his/her http password
(htpasswd) than his database password also changes. It is important to have
the same password for both services. I plan to do it from php.

Is there any way to do so?

Thans,
-- Csaba Együd

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.766 / Virus Database: 513 - Release Date: 2004.09.17.



---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Michael Fuhr]

Re: Modifying users password in pg_shadow from php

On Sat, Sep 25, 2004 at 05:40:27PM +0200, Egy?d Csaba wrote:[color=blue]
> I'm wonder if there is any possibility to modify a users password by
> updating the pg_shadow table.[/color]

Why not use ALTER USER?

http://www.postgresql.org/docs/7.4/static/sql-alteruser.html

--
Michael Fuhr

http://www.fuhr.org/~mfuhr/

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Együd Csaba]

Re: Modifying users password in pg_shadow from php

ohhhhhh thanks. what a stupid i am. ....:)))

-----Original Message-----
From: pgsql-general-owner@postgresq l.org
[mailto:pgsql-general-owner@postgresq l.org] On Behalf Of Michael Fuhr
Sent: Saturday, September 25, 2004 5:56 PM
To: Egy?d Csaba
Cc: Pgsql-General@Postgre sql.Org
Subject: Re: [GENERAL] Modifying users password in pg_shadow from php

On Sat, Sep 25, 2004 at 05:40:27PM +0200, Egy?d Csaba wrote:[color=blue]
> I'm wonder if there is any possibility to modify a users password by
> updating the pg_shadow table.[/color]

Why not use ALTER USER?

http://www.postgresql.org/docs/7.4/static/sql-alteruser.html

--
Michael Fuhr

http://www.fuhr.org/~mfuhr/

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.766 / Virus Database: 513 - Release Date: 2004.09.17.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.766 / Virus Database: 513 - Release Date: 2004.09.17.



---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match