Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 8B9129F9630; Wed, 15 Aug 2007 12:47:56 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 37405-02; Wed, 15 Aug 2007 12:47:51 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 2FCE19F960D; Wed, 15 Aug 2007 12:47:51 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 7AA4356528; Wed, 15 Aug 2007 10:47:50 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Wed, 15 Aug 2007 10:47:47 -0500 Date: Wed, 15 Aug 2007 10:47:47 -0500 From: Decibel! To: Anderson Alves de Albuquerque Cc: pgsql-admin@postgresql.org, pgsql-general@postgresql.org Subject: Re: [GENERAL] Permission ALTER PASSWORD Message-ID: <20070815154747.GE54135@nasby.net> References: <9b3f75f0708081435p23494a95gd2ac55adf3db02b3@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="xXygN3QAmJYWdGtb" Content-Disposition: inline In-Reply-To: <9b3f75f0708081435p23494a95gd2ac55adf3db02b3@mail.gmail.com> X-Operating-System: FreeBSD 6.1-RELEASE-p10 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.13 (2006-08-11) X-Hashcash: 1:20:070815:andersonaa@gmail.com::9bgULzcI/vWE+oip:00000000000000000 0000000000000000000000006u3G X-Hashcash: 1:20:070815:pgsql-admin@postgresql.org::uc6fy4m0pJcBsxIH:00000000000 0000000000000000000000002pUe X-Hashcash: 1:20:070815:pgsql-general@postgresql.org::811BDxUc7JwoogP7:000000000 0000000000000000000000001k5U X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/180 X-Sequence-Number: 26511 --xXygN3QAmJYWdGtb Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Wed, Aug 08, 2007 at 06:35:51PM -0300, Anderson Alves de Albuquerque wr= ote: > After user $USER execute this ALTER, it get change PASSWORD. Could I blo= ck > command ALTER password to user $USER? No, there's no way to do that. You might want to look at using ident-based authentication for that user instead. --=20 Decibel!, aka Jim Nasby decibel@decibel.org EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) --xXygN3QAmJYWdGtb Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.3 (FreeBSD) iD8DBQFGwyAjdO30qud8SkgRAiikAJ4phLVvmsQl7laHTTeTQGboPV3hTQCgiqr3 o6LzwltD9V9EI2aY1dYKhNQ= =yyFJ -----END PGP SIGNATURE----- --xXygN3QAmJYWdGtb--