Skip site navigation (1)Skip section navigation (2)
Date:      Sun, 06 Jun 1999 04:06:01 GMT
From:      mike@sentex.net (Mike Tancsa)
To:        questions@freebsd.org
Subject:   Re: PostgreSQL query has permission denied error
Message-ID:  <3759f35b.100357546@mail.sentex.net>
In-Reply-To: <MAIL000a01beaf74$88f55840$e06ec8d0@lexmark.com>
References:  <MAIL000a01beaf74$88f55840$e06ec8d0@lexmark.com>

next in thread | previous in thread | raw e-mail | index | archive | help
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




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?3759f35b.100357546>