Re: Simple webuser setup

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: Raw Message | Whole Thread | 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

In response to

Responses

Browse pgsql-general by date

  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