Re: Simple webuser setup - Mailing list pgsql-general

From Tino Wildenhain
Subject Re: Simple webuser setup
Date
Msg-id 44BB631E.9080100@wildenhain.de
Whole thread Raw
In response to Simple webuser setup  (msiner@gmail.com)
Responses Re: Simple webuser setup
List pgsql-general
msiner@gmail.com 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 working for
> me.  What is the simplest way to do this?  Do I need to start at the

what does "is not working for me" mean in detail?

> top and then work down (db->schema->table) or is there any cascading
> effect?  I am still pretty new to web development, so is there a
> better/easier way to achieve the same effect?

There is no cascading effect when it comes to permission but if you
dont have permission for a schema you cant access the objects in it :-)

Maybe you can use your schema script and edit it semi-automatically.

Regards
Tino



pgsql-general by date:

Previous
From: "Raymond O'Donnell"
Date:
Subject: Re: Simple webuser setup
Next
From: "polder_udo"
Date:
Subject: postgreSQL installation