[ADMIN] read only user

[Colin Taylor]

Hi there,  Ive google and searched the lists but havent found detailed instructions on how to give a user readly access to a schema. Is there a way to do this with out explictly granting the SELECT privilege on every table?

Thanks and regards,
Colin.