Re: let users change their password - Mailing list pgsql-admin

Andreas <maps.on@gmx.net> writes:
> 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).

Yeah, in recent releases an account with CREATEROLE privilege acts like
that.

            regards, tom lane