Re: trust auth in 7.4 - Mailing list pgsql-general

From Henk van Lingen
Subject Re: trust auth in 7.4
Date
Msg-id 20040122171136.GH6893@cs.uu.nl
Whole thread Raw
In response to Re: trust auth in 7.4  (Bruno Wolff III <bruno@wolff.to>)
Responses Re: trust auth in 7.4
List pgsql-general
On Thu, Jan 22, 2004 at 11:00:25AM -0600, Bruno Wolff III wrote:
  > > docs say (19.2.1):
  > >
  > >  When trust authentication is specified, PostgreSQL assumes that anyone who
  > >  can connect to the server is authorized to access the database as whatever
  > >  database user he specifies (including the database superuser). This method
  > > Which of these is right? I hope the last also holds for 'trust' lines?
  >
  > Both. The second part says that in pg_hba.conf you can say which postgres
  > users can connect to which databases. The first part says that trust
  > authentication says that postgres will allow you to be whatever user you
  > want without having to prove it in any way.

  Well, i think the first part is misleading. Trying it it seems to work
  as i hoped. If i have a line like

  host somedb bruno 192.168.5.5 255.255.255.255  trust

  bruno can connect from 192.168.5.5 but tom can't.

  I think the first part should say 'as the users specified in the specific
  pg_hba.conf line without doing further checks'.

  Never mind.

  Regards,

--
Henk van Lingen, Systems & Network Administrator              (o-      -+
Dept. of Computer Science, Utrecht University.                /\        |
phone: +31-30-2535278                                        v_/_
http://henk.vanlingen.net/             http://www.tuxtown.net/netiquette/

pgsql-general by date:

Previous
From: Jeff Bowden
Date:
Subject: Re: embedded/"serverless" (Re: serverless postgresql)
Next
From: "John Sidney-Woollett"
Date:
Subject: Re: tablespaces a priority for 7.5?