Thread: let users change their password

let users change their password

From
Andreas
Date:
  Hi,

how can I let users change their own password but noone else's ?

I could restrict this within our client-app but then I'm skrewed when
some smarty connects directly with psql.

Re: let users change their password

From
Tom Lane
Date:
Andreas <maps.on@gmx.net> 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.

            regards, tom lane

Re: let users change their password

From
Andreas
Date:
  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

Re: let users change their password

From
Tom Lane
Date:
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