Received: from sandtstudent.pyr.ec.gc.ca (fwvan1.pyr.ec.gc.ca [199.212.20.2]) by hub.org (8.10.1/8.10.1) with ESMTP id e78FviG38121 for ; Tue, 8 Aug 2000 11:57:45 -0400 (EDT) Received: from ec.gc.ca (IDENT:huangb@sandtstudent.pyr.ec.gc.ca [131.235.150.249]) by sandtstudent.pyr.ec.gc.ca (8.9.3/8.9.3) with ESMTP id IAA14499; Tue, 8 Aug 2000 08:53:38 -0700 Message-ID: <39902D01.A2C1A3B8@ec.gc.ca> Date: Tue, 08 Aug 2000 08:53:37 -0700 From: Bernie Huang Organization: Environment Canada X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.14-5.0 i686) X-Accept-Language: en MIME-Version: 1.0 To: Rob van der Leek CC: "pgsql-sql@hub.org" Subject: Re: Changing user passwords References: <39900D71.170A98BD@frog.nl> Content-Type: multipart/mixed; boundary="------------341C0EC4D5FD7DD9540FCA31" X-Archive-Number: 200008/65 This is a multi-part message in MIME format. --------------341C0EC4D5FD7DD9540FCA31 Content-Type: text/plain; charset=iso-8859-15 Content-Transfer-Encoding: 7bit Rob van der Leek wrote: > 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. > > There is no space between: eg; createuser whoever; dropuser whoever; - Bernie --------------341C0EC4D5FD7DD9540FCA31 Content-Type: text/x-vcard; charset=iso-8859-15; name="bernie.huang.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Bernie Huang Content-Disposition: attachment; filename="bernie.huang.vcf" begin:vcard n:Huang;Bernie tel;fax:(604)664-9195 tel;work:(604)664-9172 x-mozilla-html:TRUE org:Environment Canada;Standards and Technology Services adr:;;700-1200 West 73 Ave.;Vancouver;BC;V6P 6H9;Canada version:2.1 email;internet:bernie.huang@ec.gc.ca title:Programmer x-mozilla-cpt:;0 fn:Bernie Huang end:vcard --------------341C0EC4D5FD7DD9540FCA31--