What permission should I grant for a user to write?

Question

Post reply

What permission should I grant for a user to write?

SQL ORACLE

One Orange Chip

Points: 27807
More actions
September 6, 2010 at 2:39 pm

#225692

Any input will be greatly appreciated.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

WayneS SSC Guru Points: 95461 More actions · Answer 1

db_datawriter

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Steve Jones - SSC Editor SSC Guru Points: 736632 More actions · Answer 2

I tend not to like db_datawriter as it grants rights to insert/update/dlete to all tables. You might have exceptions, especially if you do any auditing.

I prefer to create a user role and then assign the permissions to tables in that role. For changing data, you need insert/update/delete permissions.

george sibbald SSC Guru Points: 104210 More actions · Answer 3

if this is via an application ideally there should be no direct access and rights are controlled via the code (which to me means stored procedures and exec rights on those procedures)

---------------------------------------------------------------------