September 24, 2013 at 3:35 pm
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
September 24, 2013 at 10:19 pm
try public permission for the database and grant update on table
http://technet.microsoft.com/en-us/library/ms188371.aspx
Regards
Durai Nagarajan
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy