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 E13299DC84B for ; Wed, 21 Dec 2005 18:16:45 -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 27175-09 for ; Wed, 21 Dec 2005 18:16:44 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from flake.decibel.org (unknown [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 902009DC84A for ; Wed, 21 Dec 2005 18:16:40 -0400 (AST) Received: by flake.decibel.org (Postfix, from userid 1001) id 173103983C; Wed, 21 Dec 2005 16:16:43 -0600 (CST) Date: Wed, 21 Dec 2005 16:16:43 -0600 From: "Jim C. Nasby" To: Donald Fraser Cc: "[ADMIN]" Subject: Re: WITH SYSID feature dropped Message-ID: <20051221221643.GJ72143@pervasive.com> References: <011501c60578$47642e40$0264a8c0@demolish1> <29845.1135094224@sss.pgh.pa.us> <012201c60583$4a832080$0264a8c0@demolish1> <20051220170345.GB11637@surnet.cl> <016a01c6064c$7cd1c040$0264a8c0@demolish1> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <016a01c6064c$7cd1c040$0264a8c0@demolish1> X-Operating-System: FreeBSD 6.0-RELEASE amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.049 required=5 tests=[AWL=0.049] X-Spam-Score: 0.049 X-Spam-Level: X-Archive-Number: 200512/256 X-Sequence-Number: 19976 On Wed, Dec 21, 2005 at 04:35:00PM -0000, Donald Fraser wrote: > Roles are a great improvement to postgresql, but we also talking security > issues here: > 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) 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. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461