Re: password

"benoit(dot)le-dizes(at)voila(dot)fr" wrote:
>I use postgresql 7.x on red hat 7.0
>
>I use pgaccess and I have created new users with password
>but when I want to open a database with a new user which normally needs a pa
>ssword, if I don't assign the password, the database is open without it.
>
>Why ?

Access control is defined by the text file pg_hba.conf. The default setting
in this file is

local all trust

which means that anyone on the local machine can log into any PostgreSQL
database as any user, without having to give a password.

Read the comments in pg_hba.conf and alter it to suit your desired access
policy.

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"But seek ye first the kingdom of God, and his
righteousness; and all these things shall be added
unto you." Matthew 6:33