Specific Grant addition to sql login base server role

• RandyO

  Right there with Babe

  Points: 771

  More actions

  February 19, 2008 at 6:21 pm

  #119987

  I need to prepare an appropriate GRANT statement to provide an existing SQL Login (lets call it mylogin) that currently has only DB_DATAREADER on a SQLServer2005 database (staying original, lets call it mydatabase), that will give it INSERT-only capability on a specific table (no delete, no update). If thats not possible then can INSERT only be added for the entire mydatabase database? Perhaps I'm missing the boat, but would appreciate any suggested syntax solutions.

  :w00t:

• thecosmictrickster@gmail.com

  SSChampion

  Points: 10386

  More actions

  February 19, 2008 at 6:28 pm

  #780016

  Check out link below in BOL for GRANT syntax. You can restrict it to columns if you really want.

  ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/c001c2e7-d092-43d4-8fa6-693b3ec4c3ea.htm

  ---

  
  Scott Duncan

  MARCUS. Why dost thou laugh? It fits not with this hour.
  TITUS. Why, I have not another tear to shed;
  --Titus Andronicus, William Shakespeare

  ---