dobiefriendly
Mr or Mrs. 500
Points: 583
More actions
September 25, 2008 at 7:17 am
#382830
I am looking for a role/permission to allow someone to apply SQL updates only. This user should not have access to view/change any database. Your assistance is greatly appreciated.
Chandra Sekhara Vyas Dhara
SSChampion
Points: 10207
September 25, 2008 at 7:32 am
#876987
You can create a role which is having data_writer permission and a member to that role
Lynn Pettis
SSC Guru
Points: 442467
September 25, 2008 at 7:44 am
#877006
Have to ask, what type of updates are you talking about, hot fixes and service packs, or data updates?
😎
September 25, 2008 at 4:43 pm
#877385
This role would only have access to apply SQL patches and service packs.
Thanks for the information and I'll test out the data_writer role.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply