Allow db access but limit commands

• homebrew01

  SSC Guru

  Points: 55553

  More actions

  September 10, 2003 at 9:53 am

  #65722

  How can I allow developers access to production databases for "select", but not allow them to "delete", "truncate", "drop" etc ... ?

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  September 10, 2003 at 9:56 am

  #473482

  'db_datareader' database role only.

• mybid2003

  SSCertifiable

  Points: 6620

  More actions

  September 10, 2003 at 10:56 am

  #473499

  Similar & Relevant post...

  http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=16123

  .