| From: | Tino Wildenhain <tino(at)wildenhain(dot)de> | 
|---|---|
| To: | msiner(at)gmail(dot)com | 
| Cc: | pgsql-general(at)postgresql(dot)org | 
| Subject: | Re: Simple webuser setup | 
| Date: | 2006-07-17 10:14:54 | 
| Message-ID: | 44BB631E.9080100@wildenhain.de | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-general | 
msiner(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John DeSoi | 2006-07-17 11:54:08 | Re: permission to create user | 
| Previous Message | polder_udo | 2006-07-17 09:25:20 | postgreSQL installation |