Обсуждение: password

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 password, if I don't assign the password, the
databaseis open without it. 

Why ?

__________________________________________________
Voila vous propose une boite aux lettres gratuite sur Voila Mail:
http://mail.voila.fr

"benoit.le-dizes@voila.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.Elphick@lfix.co.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

"Oliver Elphick" wrote:
  >  >I use pgaccess and I have created new users with password
 ...
  >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.

I should add that pgaccess uses 'local' access (Unix sockets) if the hostname
is left blank.  If you want to use TCP/IP you can set it to 'localhost',
in which case 'host' lines in pg_hba.conf will apply instead.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.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