Обсуждение: Setting Password
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
You need to change the pg_hba.conf file in your PostgreSQL installation so that "password" authentication is used. Check out: http://www.postgresql.org/idocs/index.php?client-authentication.html for details. Hope that helps, Mike Mascari mascarm@mascari.com > Balaji Venkatesan wrote: > > 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