How to set user permissions for service

• gary.monk

  Grasshopper

  Points: 11

  More actions

  September 24, 2013 at 3:35 pm

  #280277

  I have two services that I am creating. The first one is continuously adding rows to a single table and the second will look at a different table in the db to see if there is any work to be completed. If there is any work to be completed the service will update the rows in that table. I need each of these two services to be able to execute side by side.

  My question is this. How can setup user permissions so that a user has read/write on just one table and read only on the rest of the database?

  Thanks,

  Gary

• durai nagarajan

  SSCoach

  Points: 15775

  More actions

  September 24, 2013 at 10:19 pm

  #1652943

  try public permission for the database and grant update on table

  http://technet.microsoft.com/en-us/library/ms188371.aspx

  Regards
  Durai Nagarajan