Received: from post.mail.nl.demon.net (post-11.mail.nl.demon.net [194.159.73.21]) by hub.org (8.10.1/8.10.1) with ESMTP id e78DjAG88213 for ; Tue, 8 Aug 2000 09:45:11 -0400 (EDT) Received: from [195.11.249.173] (helo=frog.nl) by post.mail.nl.demon.net with esmtp (Exim 3.14 #4) id 13M9gh-0003ov-01 for pgsql-sql@hub.org; Tue, 08 Aug 2000 13:45:00 +0000 Received: from frog.nl (IDENT:rob@fnspc20.ich.nl [192.3.2.118]) by frog.nl (8.9.3/8.9.3) with ESMTP id PAA31610 for ; Tue, 8 Aug 2000 15:38:15 +0200 Message-ID: <39900D71.170A98BD@frog.nl> Date: Tue, 08 Aug 2000 15:38:57 +0200 From: Rob van der Leek Organization: FROG Navigation Systems b.v. X-Mailer: Mozilla 4.6 [en] (X11; I; Linux 2.0.36 i686) X-Accept-Language: en MIME-Version: 1.0 CC: "pgsql-sql@hub.org" Subject: Re: Changing user passwords References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200008/63 A question about the ALTER USER command I couldn't find in the standard documentation: - How do I assign an 'undefined' password? ALTER USER nobody WITH PASSWORD ""; works, but doesn't assign an undefined password to nobody (like the `pg_passwd nobody` command would do). DROP USER nobody; CREATE USER nobody; doesn't do the job either. And why does the ALTER USER command operates on pg_shadow instead of pg_passwd? (or is this configurable?) rob. - "Nagy Laszlo Zsolt , KLTE TTK pm1" wrote: > > > 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 -- Rob van der Leek E-mail: rob@frog.nl ---------------------------- FROG Navigation Systems b.v. Cartesiusweg 120 3534 BD Utrecht Tel. 030-2440550 Fax. 030-2440700 http://www.frog.nl ----------------------------