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