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.

Hi Colin,

If its a one-off I usually do this in pgadmin3 by right clicking on the
schema and doing the grant wizard from there.

Regards

Walter

On Mon, 2005-11-07 at 10:54 +1300, Colin Taylor wrote:
> 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.
--
Walter Kaan
IM/IT Manager
NSW Rural Doctors Network
www.nswrdn.com.au


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend