From owner-freebsd-questions Sat Jun 5 20:55:37 1999 Delivered-To: freebsd-questions@freebsd.org Received: from granite.sentex.net (granite.sentex.ca [199.212.134.1]) by hub.freebsd.org (Postfix) with ESMTP id 5D9F4152C9 for ; Sat, 5 Jun 1999 20:55:35 -0700 (PDT) (envelope-from mike@sentex.net) Received: from ospf-wat.sentex.net (ospf-wat.sentex.net [209.167.248.81]) by granite.sentex.net (8.8.8/8.6.9) with SMTP id XAA04543 for ; Sat, 5 Jun 1999 23:55:35 -0400 (EDT) From: mike@sentex.net (Mike Tancsa) To: questions@freebsd.org Subject: Re: PostgreSQL query has permission denied error Date: Sun, 06 Jun 1999 04:06:01 GMT Message-ID: <3759f35b.100357546@mail.sentex.net> References: In-Reply-To: X-Mailer: Forte Agent .99e/32.227 Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On 5 Jun 1999 12:57:43 -0400, in sentex.lists.freebsd.questions you wrote: >Since I don't understand what is going on here, I tried logging >into my BSD account as root, pgsql and postgres, and accessing >the web page, but I received the same error. > >I do not know how to list the pgsql users and privelages, if that info is >needed. Check the postgres documentation, specifically the section talking about grant. My guess is that you have not granted select permissions to the webuser. ---Mike Mike Tancsa (mdtancsa@sentex.net) Sentex Communications Corp, Waterloo, Ontario, Canada To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message