Artur Pietruk wrote:
> On Mon, Jul 22, 2002 at 12:16:53PM +0200, Vicente Vives wrote:
> > Hi .
> > I have a server running PostgreSQL Version 6.5, and i have a problem.
> > I grant some distinct privileges to some users (and that works). The
> > problem
> > is that those users can log in with any password. Each user has a
> > password
> > assigned but not matter the password the user use to log in, if the user
> > exists always will get access to the database.
> Go to your $PGDATA directory, and check your pg_hba.conf. That's
> file where you can confiure access do your db - it is wery well commented,
> read it and you will find out what to do (if not, go to docs and read about
> pg_hba.conf). It looks, that you may have "trust" enabled for local
> connections (or for whatever way they are connecting), or something like
> that, and that is why users are authenticated without their passwords.
In my pg_hba.conf the option 'trust' was enabled. If i changed it to
'crypt' the users can access correctly.
Thank you very much!
In response to
pgsql-admin by date
|Next:||From: Ronny Theunissen||Date: 2002-07-22 12:35:50|
|Subject: using an index with like-operator|
|Previous:||From: Thorsten Ottosen||Date: 2002-07-22 11:56:54|
|Subject: Re: initdb on cygwin|