Schema level permissions

• SQListic

  SSCertifiable

  Points: 6904

  More actions

  August 16, 2013 at 10:31 am

  #297720

  Hi Experts:

  Requirement: We have three schemas in one database known as NY, CA and DM. Users should only have select on NY and CA schemas but should have select, update, insert, delete truncate, execute on DM schema. Is this is possible ?

• starflyer

  SSC Eights!

  Points: 979

  More actions

  August 16, 2013 at 11:11 am

  #1642274

  Is this what you are looking for:

  GRANT SELECT,UPDATE,INSERT,DELETE,EXECUTE ON SCHEMA::DM TO User;

  GRANT SELECT ON SCHEMA::NY TO User;

  GRANT SELECT ON SCHEMA::CA TO User;