• You can try syntax in following pattern:

    GRANT <permission> on <Object Name> to <User Name1>, <User Name2>..... <User Name n>

    example:

    grant select on test to SQLVillage,SQLVillage_Reader

    P.S. Realized little later that Perry Whittle has already answered

    [font="Verdana"]--www.sqlvillage.com[/size][/font]