pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
From: Stephen Frost <sfrost@snowman.net>
To: Donald Fraser <postgres@kiwi-fraser.net>
Cc: [ADMIN] <pgsql-admin@postgresql.org>
Subject: Re: WITH SYSID feature dropped
Date: Fri, 23 Dec 2005 09:13:58 -0500
Message-ID: <20051223141358.GF6026@ns.snowman.net> (raw)
In-Reply-To: <01d701c607b7$ff8c6b40$0264a8c0@demolish1>
References: <011501c60578$47642e40$0264a8c0@demolish1>
<29845.1135094224@sss.pgh.pa.us>
<012201c60583$4a832080$0264a8c0@demolish1>
<20051220170345.GB11637@surnet.cl>
<016a01c6064c$7cd1c040$0264a8c0@demolish1>
<20051221221643.GJ72143@pervasive.com>
<01d701c607b7$ff8c6b40$0264a8c0@demolish1>
* Donald Fraser (postgres@kiwi-fraser.net) wrote:
> > On Wed, Dec 21, 2005 at 04:35:00PM -0000, Donald Fraser wrote:
> > > Our module controls things like:
> > > 1) how long before a user must change their password (daily, weekly,
> > > monthly etc)
> > > 2) password rotation - for example a user cannot use the same password
> > > within the last three changes
> > > 3) Password semantics: length of password, dictionary word checks and so
> > > on...
> > > 4) Restricting a users rights until they have changed their password
> > > (they cannot use the system until they change the password set by
> > > the administrator)
>
> From: "Jim C. Nasby"
> > Can you release any of that code under a BSD license? Some of those
> > should arguably be built-in. If nothing else, it would be good reference
> > code for others. Though, you can set a 'valid until' limit on roles
> > right now, but I suppose that's not exactly the same as what you have.
I definitely agree that it'd be nice to have some of these built in. On
the other hand, PAM can do much of this but that requires appropriate
access to the various system files. SASL is another thought but I'm not
sure if it can do even most of that (without having it using PAM
underneath which I understand is rather ugly).
I'd really like to get rid of the rather hackish PAM solution I've got
right now and so I wouldn't mind spending time looking into implementing
some of these things as built-ins. The part that makes me nervous about
that is if it would require protocol changes and/or additional library
dependencies that some might not care for.
Thanks,
Stephen
Attachments:
signature.asc (application/pgp-signature, 188B) download
view thread (13+ messages)
Message-ID: <20051223141358.GF6026@ns.snowman.net> Permalink: ../20051223141358.GF6026@ns.snowman.net/ Also on: postgresql.org/message-id/20051223141358.GF6026@ns.snowman.net ·
reply
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Reply to all the recipients from your mail client; the link fills in the headers below: reply via email Some clients, webmail especially, drop In-Reply-To and References from a link, and the reply then starts a new thread: use the mbox below. To: pgsql-admin@postgresql.org Cc: sfrost@snowman.net, postgres@kiwi-fraser.net Subject: Re: WITH SYSID feature dropped In-Reply-To: <20051223141358.GF6026@ns.snowman.net> References: <011501c60578$47642e40$0264a8c0@demolish1> <29845.1135094224@sss.pgh.pa.us> <012201c60583$4a832080$0264a8c0@demolish1> <20051220170345.GB11637@surnet.cl> <016a01c6064c$7cd1c040$0264a8c0@demolish1> <20051221221643.GJ72143@pervasive.com> <01d701c607b7$ff8c6b40$0264a8c0@demolish1> <20051223141358.GF6026@ns.snowman.net> * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox