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 (<alvherre[a]alvh.no-ip.org>)
"Y eso te lo doy firmado con mis lágrimas" (Fiebre del Loco)