Re: let users change their password

Am 25.08.2010 03:29, schrieb Tom Lane:
> Andreas writes:
>> how can I let users change their own password but noone else's ?
> Uh, that's the normal behavior, no? At least for non-superusers.
aaaaaarghl ... right ... 8-}

Thanks Tom

Now, lets make it more difficult then.
Is there a way to have a sub-admin who should be able to create and drop
roles as well as change passwords for every user who is non-superuser
(or at least not for me and postgres).
I prefered not to get locked out when I delegate the user management.

Andreas