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