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
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
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?
[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
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