From owner-freebsd-questions Sat Jun 5 10:37:43 1999 Delivered-To: freebsd-questions@freebsd.org Received: from carbine.holster.placo.com (carbine.holster.placo.com [199.2.210.227]) by hub.freebsd.org (Postfix) with ESMTP id B441C14CA4 for ; Sat, 5 Jun 1999 10:37:36 -0700 (PDT) (envelope-from doug@carbine.holster.placo.com) Received: (from doug@localhost) by carbine.holster.placo.com (8.8.5/8.8.5) id KAA29746; Sat, 5 Jun 1999 10:37:27 -0700 (PDT) Date: Sat, 5 Jun 1999 10:37:26 -0700 (PDT) From: Douglas Jackson To: Jim Freeze Cc: pgsql-novice@postgreSQL.org, freebsd-questions@FreeBSD.ORG Subject: Re: [NOVICE] PostgreSQL query has permission denied error In-Reply-To: <000a01beaf74$88f55840$e06ec8d0@lexmark.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On Sat, 5 Jun 1999, Jim Freeze wrote: > I am using FreeBSD 3.1 and netscape on a standalone system. > I have the ports install of apache, php3 and postgreSQL installed. > > In case it helps, the following is an excerpt of my passwd file. > > nobody:*:65534:65534:Unprivileged user:/nonexistent:/sbin/nologin If your apache webserver is executing your PHP scripts as user "nobody", then you need to tell you pgsql database that "nobody" is allowed to access the database. To do this, use the "createuser" command from the shell. Do this as user postgres. Then once "nobody" can connect to the database, he'll also need individual privileges on the tables, so he can "select" from them. Use the "grant" sql command to do this. Doug -- Douglas Jackson doug@carbine.holster.placo.com http://carbine.holster.placo.com/~doug pgp public key: http://carbine.holster.placo.com/~doug/doug-pub.asc To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message