[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 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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
