Re: How to revoke a password

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 ()
"Y eso te lo doy firmado con mis lágrimas" (Fiebre del Loco)