[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
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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
