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 BC570D7EB7 for ; Thu, 22 Sep 2005 21:31:26 -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 69555-06 for ; Fri, 23 Sep 2005 00:31:18 +0000 (GMT) Received: from nibbel.kulnet.kuleuven.ac.be (nibbel.kulnet.kuleuven.ac.be [134.58.240.41]) by svr1.postgresql.org (Postfix) with ESMTP id 3992FD7A16 for ; Thu, 22 Sep 2005 21:31:19 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by nibbel.kulnet.kuleuven.ac.be (Postfix) with ESMTP id 2C82D4C245; Fri, 23 Sep 2005 02:31:22 +0200 (CEST) Received: from smtp01.kuleuven.be (octavianus.kulnet.kuleuven.ac.be [134.58.240.71]) by nibbel.kulnet.kuleuven.ac.be (Postfix) with ESMTP id 830484C23D; Fri, 23 Sep 2005 02:31:21 +0200 (CEST) Received: from 10-4-154-137.kotnet.org (10-4-154-137.kotnet.org [10.4.154.137]) by smtp01.kuleuven.be (Postfix) with ESMTP id 7083963D84; Fri, 23 Sep 2005 02:31:18 +0200 (CEST) From: Wim Bertels Reply-To: wim.bertels@khleuven.be Organization: KHLeuven Departement Rega To: "Scott Marlowe" Subject: Re: alter user Date: Fri, 23 Sep 2005 02:32:51 +0200 User-Agent: KMail/1.6.2 Cc: References: In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/signed; protocol="application/pgp-signature"; micalg=pgp-sha1; boundary="Boundary-02=_600MD4hb9OaGPk4"; charset="utf-8" Content-Transfer-Encoding: 7bit Message-Id: <200509230232.58668.wim.bertels@khleuven.be> X-Virus-Scanned: by KULeuven Antivirus Cluster X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.038 required=5 tests=[AWL=-0.013, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200509/248 X-Sequence-Number: 18985 --Boundary-02=_600MD4hb9OaGPk4 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On Friday 23 September 2005 01:51, Scott Marlowe seinde rooksignalen: > Instead of using a general purpose account, why not give everyone an > account, then make them a member of a group, and give that group the > access. > > That way you can easily add / remove people from the group instead of > trying to do it this way. not an option, its for scripting and testing purposes > > Otherwise, don't use a password, set the machine to use trust or ident or > something like that where a password wouldn't matter. although it is then a user/pasword known by a lot of people, it is still beter than no password > > -----Original Message----- > From: pgsql-admin-owner@postgresql.org on behalf of Wim Bertels > Sent: Thu 9/22/2005 6:13 PM > To: pgsql-admin@postgresql.org > Subject: [ADMIN] alter user > > 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) t= he > change the password, leaving the rest clueless.. > > suggestions to prevent this?, i need a general (readonly) user! =2D-=20 Wim Bertels --Boundary-02=_600MD4hb9OaGPk4 Content-Type: application/pgp-signature Content-Description: signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQBDM006Fj4TNdVKYYsRAlGvAJ9GUm7Hudc8Fpd91zBDTFjZGS+xFgCfd0q2 xetcxhaMObOGuJoNNAm07S4= =hHEB -----END PGP SIGNATURE----- --Boundary-02=_600MD4hb9OaGPk4--