I create tables as one user then I want another user to use those tables (like the web server). Then I need to GRANT access to every object in the database to that other user.
http://www.postgresql.org/docs/7.4/static/groups.htmlThis allows you to establish groups so that you can have Big_user with read/write and Lil_user with read only.