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 75994D7115 for ; Thu, 22 Sep 2005 20:12:11 -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 48368-01 for ; Thu, 22 Sep 2005 23:12:05 +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 93EA5D6FDB for ; Thu, 22 Sep 2005 20:12:05 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by nibbel.kulnet.kuleuven.ac.be (Postfix) with ESMTP id E8CE44C3BA for ; Fri, 23 Sep 2005 01:12:06 +0200 (CEST) Received: from smtp02.kuleuven.be (lepidus.kulnet.kuleuven.ac.be [134.58.240.72]) by nibbel.kulnet.kuleuven.ac.be (Postfix) with ESMTP id 671274C1D5 for ; Fri, 23 Sep 2005 01:12:06 +0200 (CEST) Received: from 10-4-154-137.kotnet.org (10-4-154-137.kotnet.org [10.4.154.137]) by smtp02.kuleuven.be (Postfix) with ESMTP id 55AAE2CAA3B for ; Fri, 23 Sep 2005 01:12:03 +0200 (CEST) From: Wim Bertels Reply-To: wim.bertels@khleuven.be Organization: KHLeuven Departement Rega To: pgsql-admin@postgresql.org Subject: alter user Date: Fri, 23 Sep 2005 01:13:37 +0200 User-Agent: KMail/1.6.2 MIME-Version: 1.0 Content-Type: multipart/signed; protocol="application/pgp-signature"; micalg=pgp-sha1; boundary="Boundary-02=_nqzMDxDKmmQZg7C"; charset="us-ascii" Content-Transfer-Encoding: 7bit Message-Id: <200509230113.43312.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.025 required=5 tests=[AWL=-0.025, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200509/244 X-Sequence-Number: 18981 --Boundary-02=_nqzMDxDKmmQZg7C Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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= =20 change the password, leaving the rest clueless.. suggestions to prevent this?, i need a general (readonly) user! =2D-=20 Wim Bertels --Boundary-02=_nqzMDxDKmmQZg7C Content-Type: application/pgp-signature Content-Description: signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQBDMzqnFj4TNdVKYYsRAvbYAJwODTtIE9nohkQits+fUJUfmyqUkgCeM3kS EVd5w0Qu/+ejtIfh0aHujTI= =0pq1 -----END PGP SIGNATURE----- --Boundary-02=_nqzMDxDKmmQZg7C--