[GENERAL] postgresql 7 user passwords dont work ?????

[Eric Webber]

users dont seem to need password in postgres 7 on red hat linux 
6.2, compiled from source. 

I do an: 

    alter user nsadmin with password 'whatever'; 

And then when I do an: 

    psql -u -d mydb 

username: nsadmin password: NOTwhatever 

IT STILL LETS ME IN ???? 

This should not be so should it ? 

please advise, thanks 

[EMAIL PROTECTED] 






________________________________________________
Get your own "800" number - Free
Free voicemail, fax, email, and a lot more
http://www.ureach.com/reg/tag