What capabilities do we have for removing a user's password? The only
way I can see to do it is to insert a NULL into pg_shadow, but clearly
that is pretty ugly. I don't see any mention in the ALTER USER manual
page, and assigning a password of NULL using ALTER user fails.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073