X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 8AC0F9DC825 for ; Fri, 23 Dec 2005 10:13:09 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 75006-09 for ; Fri, 23 Dec 2005 10:13:13 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from ns.snowman.net (ns.snowman.net [66.92.160.21]) by postgresql.org (Postfix) with ESMTP id 079389DC818 for ; Fri, 23 Dec 2005 10:13:07 -0400 (AST) Received: by ns.snowman.net (Postfix, from userid 1000) id E94E517B08; Fri, 23 Dec 2005 09:13:58 -0500 (EST) Date: Fri, 23 Dec 2005 09:13:58 -0500 From: Stephen Frost To: Donald Fraser Cc: "[ADMIN]" Subject: Re: WITH SYSID feature dropped Message-ID: <20051223141358.GF6026@ns.snowman.net> Mail-Followup-To: Donald Fraser , "[ADMIN]" 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> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="Ief0lssa8kIajGHC" Content-Disposition: inline In-Reply-To: <01d701c607b7$ff8c6b40$0264a8c0@demolish1> X-Editor: Vim http://www.vim.org/ X-Info: http://www.snowman.net X-Operating-System: Linux/2.4.24ns.3.0 (i686) X-Uptime: 09:08:01 up 195 days, 6:19, 11 users, load average: 0.10, 0.19, 0.10 User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.09 required=5 tests=[AWL=0.090] X-Spam-Score: 0.09 X-Spam-Level: X-Archive-Number: 200512/300 X-Sequence-Number: 20020 --Ief0lssa8kIajGHC Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable * 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=20 > > > the administrator) >=20 > 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 --Ief0lssa8kIajGHC Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (GNU/Linux) iD8DBQFDrAYmrzgMPqB3kigRAvVcAKCWky5QdMX6rgcgx5S+mv0/gvcn4wCeM1zE OHTbdkGyG5Pq3wVbixv6xvc= =BQaR -----END PGP SIGNATURE----- --Ief0lssa8kIajGHC--