Date: Sat, 5 Jun 1999 10:37:26 -0700 (PDT) From: Douglas Jackson <doug@carbine.holster.placo.com> To: Jim Freeze <jim@freeze.org> Cc: pgsql-novice@postgreSQL.org, freebsd-questions@FreeBSD.ORG Subject: Re: [NOVICE] PostgreSQL query has permission denied error Message-ID: <Pine.BSF.3.91.990605103327.29727A-100000@carbine.holster.placo.com> In-Reply-To: <000a01beaf74$88f55840$e06ec8d0@lexmark.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.BSF.3.91.990605103327.29727A-100000>