Re: [GENERAL] Simple webuser setup

2006-07-18 Thread Raymond O'Donnell
On 17 Jul 2006 at 6:08, [EMAIL PROTECTED] wrote: > to get this effect for the above? What permissions do I need for the > db, schema, and table? I have a user named "webuser" belonging to a > group named "webgroup" and I am granting the above privileges to > webgroup. All you really need is the

Re: [GENERAL] Simple webuser setup

2006-07-18 Thread Raymond O'Donnell
On 17 Jul 2006 at 6:08, [EMAIL PROTECTED] 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

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

Re: [GENERAL] Simple webuser setup

2006-07-17 Thread Tony Caduto
[EMAIL PROTECTED] wrote: 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 work

Re: [GENERAL] Simple webuser setup

2006-07-17 Thread Tino Wildenhain
[EMAIL PROTECTED] wrote: 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 work

Re: [GENERAL] Simple webuser setup

2006-07-17 Thread Raymond O'Donnell
On 16 Jul 2006 at 17:12, [EMAIL PROTECTED] wrote: > 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

[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