Re: [ADMIN] password administration - Mailing list pgsql-admin

From Adam Maddock
Subject Re: [ADMIN] password administration
Date
Msg-id Pine.LNX.3.96.981217100103.5521A-100000@apu.maddock.net
Whole thread Raw
In response to Re: [ADMIN] password administration  (Charles Curley <charles.h.curley@lmco.com>)
List pgsql-admin
Hmm... that doesn't work on my system because my system's logon/passwd
commands use a different encryption altorhythm than Postgres.  I wonder if
there is a way to change one or the other's scheme.  Did you have to hack
anything or did it work "out-of-the-box"?

My Linux kernel is 2.0.34 and my distribution is Slackware 3.5.

On Thu, 17 Dec 1998, Charles Curley wrote:

> 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
>
>


pgsql-admin by date:

Previous
From: Charles Curley
Date:
Subject: Re: [ADMIN] password administration
Next
From: Carl Riches
Date:
Subject: More problems compiling PostgreSQL 6.4 on Digital Unix 4.0d