grant database roles to read-only specified schema

Hi,

I'm trying to grant a database roles (contract_role) to have "select" to the
tables within schema1. Is there a way that I can grant select on all of the
tables to contract_role instead of choosing one by one and click?

Thanks
Sarah

Sarah,

GRANT SELECT ON SCHEMA :: schema1 TO contract_role

RLF

"sg" wrote in message

> Hi,
>
> I'm trying to grant a database roles (contract_role) to have "select" to
> the
> tables within schema1. Is there a way that I can grant select on all of
> the
> tables to contract_role instead of choosing one by one and click?
>
> Thanks
> Sarah