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
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
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
[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
[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
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
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