| From: | Mark Fenbers <Mark(dot)Fenbers(at)noaa(dot)gov> | 
|---|---|
| To: | PostgreSQL - SQL <pgsql-sql(at)postgresql(dot)org> | 
| Subject: | drop PW | 
| Date: | 2009-06-13 20:51:20 | 
| Message-ID: | 4A341148.3040102@noaa.gov | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-sql | 
I have created a new 8.3 version DB and populated it.  A specific user 
of this database (george) has been setup with a password, so that every 
time I use psql or some other utility, I need to supply this password.  
So I want to drop the password authentication.  I tried rerunning 
createuser (and just pressing Enter when prompted for the new password), 
but it complains that the user already exists.  I can't drop the user 
because this user owns the DB and all the tables.  My postgresql books 
are all for 7.x, and suggests altering the pg_shadow table (which seems 
risky to me).  I tried:
ALTER USER george PASSWORD '';
and that looked like it succeeded, but running psql again prompted me 
and when I just hit Enter, it complained that no password was supplied.
So how do I turn off being prompted for a password for george.  (I am 
aware of the security risks...)
Mark
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua Tolley | 2009-06-13 20:55:01 | Re: drop PW | 
| Previous Message | Seb | 2009-06-13 00:22:27 | Re: updateable/insertable view having left joined tables |