[HACKERS] Setting Password

[Balaji Venkatesan]

Hi List,      Iam pretty new to this list as well as PostgreSQL. I hope to find some crucial info from here. Thnx in advance to all those who would contribute to it.   Iam basically an Oracle Consultant.   At first i would like to clarify how to enforce password for a user i have created.  I use the psql client to access the database and unless and until the -U option (psql template1 -U <user> ) is used, iam not prompted to enter any password. Even thou i enter a wrong password iam still allowed to log in. Is there any property needs to be altered to enforce the same ? Looking forward for some favourable responses. Regards Balaji