GRANT on database

Hi,

How do I grant all on database TO PUBLIC?
Without having to go through each table in that database?

Basically I have created a databases as one user, and I want another
user
to be able to access all tables in that database. However
when i run simple query like "SELECT * from tablename"  as that "other
user"
it gives me (ERROR:  tablename: Permission denied).

GRANT doesnt let you grant access to the entire databases , only tables.
and since I have over 30 tables in my DB goin through each table and
setting
permissions by hand is too time consuming.



Regards,
Boulat.



--
Nothing Like the Sun