Re: [GENERAL] Simple webuser setup

2006-07-18 Thread msiner
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 I can think of, but none see

[GENERAL] Simple webuser setup

2006-07-16 Thread msiner
There must be something simple that I am missing, but here is my problem. I am setting up a standard pg install as a backend to a small webapp. I want to create a user "webuser" with only enough privileges to query all of the tables in my database. It has not been working for me. What is the si