X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id EEA63D7A0A for ; Fri, 23 Sep 2005 01:09:29 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 31208-10 for ; Fri, 23 Sep 2005 04:09:26 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.197.194]) by svr1.postgresql.org (Postfix) with SMTP id F2694D88B7 for ; Fri, 23 Sep 2005 01:09:25 -0300 (ADT) Received: (qmail 20172 invoked by uid 500); 23 Sep 2005 04:10:09 -0000 Date: Thu, 22 Sep 2005 23:10:09 -0500 From: Bruno Wolff III To: Wim Bertels Cc: pgsql-admin@postgresql.org Subject: Re: alter user Message-ID: <20050923041009.GA19555@wolff.to> Mail-Followup-To: Bruno Wolff III , Wim Bertels , pgsql-admin@postgresql.org References: <200509230113.43312.wim.bertels@khleuven.be> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200509230113.43312.wim.bertels@khleuven.be> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006] X-Spam-Level: X-Archive-Number: 200509/250 X-Sequence-Number: 18987 On Fri, Sep 23, 2005 at 01:13:37 +0200, Wim Bertels wrote: > Ls, > > any user can change his own password, > i haven't found a way of prohibiting this. > what about a general user (eg test/test), that is used by many people, > one of those people could use alter user (being connected as test/test) the > change the password, leaving the rest clueless.. > > suggestions to prevent this?, i need a general (readonly) user! Tell people not to do this. Use ident authentication. Give each person their own postgres account.