Re: Removing a user's password

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Rodolfo J(dot) Paiz" <rpaiz(at)simpaticus(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Removing a user's password
Date: 2005-01-25 03:39:43
Message-ID: 28881.1106624383@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Rodolfo J. Paiz" <rpaiz(at)simpaticus(dot)com> writes:
> I have learned how to ALTER USER to both set a password and change a
> password. However, I can't seem to *remove* a password.

AFAIR this isn't supported directly. You can get the effect in two ways
though:

1. (language lawyer's way)

ALTER USER luser WITH VALID UNTIL 'yesterday';

The password is still there, but no longer usable.

2. (hacker's way)

UPDATE pg_shadow SET passwd = NULL WHERE usename = 'luser';

This really does reset the password, but it involves more intimacy with
the current system catalog representation than you might like --- ie,
it might possibly break in some future version of Postgres.

regards, tom lane

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Fuhr 2005-01-25 04:05:08 Re: extracting date from timestamp
Previous Message Alexander Borkowski 2005-01-25 02:54:41 Re: recommended programming language for postgresql