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
> 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?
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
>
You just have to set it at the table level.
You should check out PG Lightning Admin, it has a really nice Grant
Manager that is grid based that makes this sort of thing
very easy to setup.
--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration