Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by postgresql.org (Postfix) with ESMTP id E26D1475AE5 for ; Fri, 19 Apr 2002 12:10:25 -0400 (EDT) Received: from [63.195.55.98] (account ) by davinci.ethosmedia.com (CommuniGate Pro WebUser 3.5.9) with HTTP id 1377481; Fri, 19 Apr 2002 09:10:30 -0700 From: "Josh Berkus" Subject: Re: Security - local(TRUST) and php/perl access To: "Dave" , X-Mailer: CommuniGate Pro Web Mailer v.3.5.9 Date: Fri, 19 Apr 2002 09:10:30 -0700 Message-ID: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit X-Archive-Number: 200204/67 X-Sequence-Number: 1091 Dave, > Currently we TRUST local users so pretty much any user can access any > database > from the shell. > When PHP or Perl(DBI) accesses the postgres database, can they simply > specify > any userid and database set as a local user would, or are they > restricted to the > "host sameuser 0.0.0.0 0.0.0.0 password" setting in pg_hba.conf Anything running on the same machine, whether a shell, PHP, or Perl, is covered by the "trust" statement, unless you make the mistake of routing your connection through an external interface. However, I strongly reccommend against using "trust" on any public web server. -Josh Berkus