| From: | "Raymond O'Donnell" <rod(at)iol(dot)ie> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org, msiner(at)gmail(dot)com |
| Subject: | Re: Simple webuser setup |
| Date: | 2006-07-18 16:43:04 |
| Message-ID: | 44BD1DA8.13074.2B515B@rod.iol.ie |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 17 Jul 2006 at 6:08, msiner(at)gmail(dot)com wrote:
> I have a db named archive, a schema named library, and a table named
> book. I have granted USAGE on library to webuser and SELECT on book
> to webuser. When I try to do a select I get an error saying
> "permission denied for schema library". I have tried every combination
How are you accessing the DB from your web app? What
language/envoronment are you using?
Are you sure that the username/password combination is being passed
along to the DB? - have you tried connecting directly to the DB using
psql, logging in as webuser, and running queries against the DB?
--Ray.
----------------------------------------------------------------------
Raymond O'Donnell
Director of Music, Galway Cathedral, Galway, Ireland
rod(at)iol(dot)ie
----------------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Raymond O'Donnell | 2006-07-18 16:49:09 | Re: Simple webuser setup |
| Previous Message | Curtis Scheer | 2006-07-18 16:27:01 | How to pass array of values to a pgplsql function |