May 7, 2009 at 1:26 pm
Hi,
I have to create a user and give him Insert,delete and update permissions.
Which dbrole should I assign for the user?
May 7, 2009 at 4:16 pm
db_datawriter. You'll probably want to add the user to db_datareader also so he can select data.
Greg
May 8, 2009 at 6:50 am
I have to disagree with Greg on this one. Create a role that has the necessary permissions and assign the user to the role. The db_datareader and db_datawriter roles grant permission to read and write to every table in the database, and tables created later that you may not want all users to have rights to.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 8, 2009 at 11:45 am
Okay, I'll give that one, Jack. My answer was probably a bit broad considering the little information the OP gave us.
Greg
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply