I don't know about secure but what I've done is linked the pg_passwd file to
/etc/passwd and then people remote ODBC user can change their database
password via the passwd command (or yppasswd). I've got a RH 5.0 system
running without shadowed password but with NIS. I'm curious what people think
of this from a security standpoint.
Adam Maddock wrote:
> Hi All,
>
> As one who is fairly new (within the last two months) to Postgre, I've
> looked through the Archives for this list a bit and have seen this issue
> addressed a number of times, but no strong solutions posted. Has anybody
> devised a good/secure way of allowing users to control their own password
> on a Postgre system?
>
> I'm hoping that either somebody already has a solution to this or that
> this will possibly spark some discussion on the topic.
>
> Thanks,
> Adam
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Adam Maddock http://Adam.Maddock.com
> Detroit, MI adam@maddock.com
> "BE IMITATORS of God, therefore, as dearly loved children..."
> (Ephesians 5:1)
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--
Charles Curley, Staff Engineer
Computer Integrated Manufacturing
Lockheed Martin Ocala Operations