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

From Andreas
Subject Re: let users change their password
Date
Msg-id 4C748099.4030208@gmx.net
Whole thread Raw
In response to Re: let users change their password  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: let users change their password  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
  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

pgsql-admin by date:

Previous
From: Fábio Gibon - Comex System
Date:
Subject: PostgreSQL 8.4 x Win 2008 - slow connection
Next
From: Tom Lane
Date:
Subject: Re: let users change their password