Thread: Modifying users password in pg_shadow from php
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.
On Sat, Sep 25, 2004 at 05:40:27PM +0200, Egy?d Csaba wrote: > I'm wonder if there is any possibility to modify a users password by > updating the pg_shadow table. Why not use ALTER USER? http://www.postgresql.org/docs/7.4/static/sql-alteruser.html -- Michael Fuhr http://www.fuhr.org/~mfuhr/
ohhhhhh thanks. what a stupid i am. ....:))) -----Original Message----- From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Michael Fuhr Sent: Saturday, September 25, 2004 5:56 PM To: Egy?d Csaba Cc: Pgsql-General@Postgresql.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: > I'm wonder if there is any possibility to modify a users password by > updating the pg_shadow table. 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.