On Fri, Jul 08, 2005 at 05:09:48PM -0700, Joshua D. Drake wrote: > Bailey, Larry wrote: > >I created a user with a password. That newly created user now have > >tables and indexes. I want to ALTER that user to exclude the password. > >How is this accomplished without dropping and recreating the users? > > Never tried to go backwards before but: > > alter user foo with encrypted password '';
I think you use NULL as password to ALTER USER. -- Alvaro Herrera (<alvherre[a]alvh.no-ip.org>) "Y eso te lo doy firmado con mis lágrimas" (Fiebre del Loco) ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
