Received: from dragon.klte.hu (dragon.klte.hu [193.6.138.65]) by hub.org (8.10.1/8.10.1) with ESMTP id e78CsnG29075 for ; Tue, 8 Aug 2000 08:54:50 -0400 (EDT) Received: from localhost (nagylzs@localhost) by dragon.klte.hu (8.9.3/8.9.3) with ESMTP id OAA20522; Tue, 8 Aug 2000 14:59:21 +0200 (MET DST) Date: Tue, 8 Aug 2000 14:59:20 +0200 (MET DST) From: "Nagy Laszlo Zsolt , KLTE TTK pm1" X-Sender: nagylzs@dragon To: Rob van der Leek cc: "pgsql-sql@hub.org" Subject: Re: Changing user passwords In-Reply-To: <398ED2F5.17A0899C@frog.nl> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200008/62 > Is it possible to change a user's password without using the pg_passwd > command? > For example, how does a user changes his password from the interactive > monitor? See the following commands: CREATE USER ALTER USER CREATE GROUP ALTER GROUP For example: ALTER USER user1 WITH PASSWORD 'password1'; Please note thatuser passwords cannot be changed in a transaction. ( 7.0.2 ) Laci 1.0