[PERFORM] How to revoke a password

2005-07-08 Thread Bailey, Larry
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? Larry Bailey Sr. Oracle DBA First American Real Estate Solution (714) 701-3347 [EMAIL

Re: [PERFORM] How to revoke a password

2005-07-08 Thread Joshua D. Drake
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

Re: [PERFORM] How to revoke a password

2005-07-08 Thread Alvaro Herrera
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?

Re: [PERFORM] How to revoke a password

2005-07-08 Thread Joshua D. Drake
[mailto:[EMAIL PROTECTED] Sent: Friday, July 08, 2005 5:10 PM To: Bailey, Larry Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] How to revoke a password Bailey, Larry wrote: I created a user with a password. That newly created user now have tables and indexes. I want to ALTER

Re: [PERFORM] How to revoke a password

2005-07-08 Thread Michael Fuhr
On Fri, Jul 08, 2005 at 05:16:27PM -0700, Bailey, Larry wrote: Thanks but it is still prompting for a password. Let's back up a bit: what problem are you trying to solve? Do you want the user to be able to log in without entering a password? If so then see Client Authentication in the