SQL Server 2000 - grant exec X grant select conflict

• sergiobonfim

  SSC Enthusiast

  Points: 122

  More actions

  August 19, 2010 at 2:59 pm

  #141666

  Hi,

  Is possible that you faced this problem. Working as DBA I created one new user on my db_tst, one new table. Then I granted for this new user just select access. Then I created one simple store procedure where I wrote one update command on this table. I granted exec for this user. Just exec.

  So when I executed the new store procedure mentioned above with this user, without grant to update, insert or delete, I checked out the the data on a table was modified. Using the store procedure.

  So, I tried to work with the reader, writer roles. So, can you help me fix these problems. This is means that when my user don't have grant to update a table, I would like to receive one warning about.

  Any idea?

  Thanks,

  Sergio

• Derrick Smith

  SSChampion

  Points: 10833

  More actions

  August 19, 2010 at 3:25 pm

  #1209382

  If all the SP does is update the table, why give them access to it in the first place?