Received: from web1.nexusinternetsolutions.net (web1.nexusinternetsolutions.net [206.47.131.12]) by postgresql.org (Postfix) with SMTP id 999E947594B for ; Fri, 19 Apr 2002 09:55:55 -0400 (EDT) Received: (qmail 74192 invoked from network); 19 Apr 2002 14:08:04 -0000 Received: from unknown (HELO cr159591a) (24.102.18.54) by web1.nexusinternetsolutions.net with SMTP; 19 Apr 2002 14:08:04 -0000 From: "Dave" To: Subject: Security - local(TRUST) and php/perl access Date: Fri, 19 Apr 2002 10:01:14 -0400 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Importance: Normal X-Archive-Number: 200204/64 X-Sequence-Number: 1088 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 Dave