[Last Call] Learn how to a build a cloud-first strategyRegister Now


Read access and permissions

Posted on 2009-12-15
Medium Priority
Last Modified: 2012-05-08
If an user is given the DB role of db_datareader, do they need to be given separate 'select' permissions on the tables, views etc? Likewise 'Update' for db_datawriter?
Question by:anushahanna

Accepted Solution

VeeNashi earned 1000 total points
ID: 26059773
no db_datareader and db_datawrite is sufficient.

Assisted Solution

sureshchsahu earned 1000 total points
ID: 26059814
Members of the db_datareader fixed database role can run a SELECT statement against any table or view in the database.

Members of the db_datawriter fixed database role can add, delete, or change data in all user tables.

One point that we have to remember while Deleting and updating with a WHERE clause requires that the data be readable so the correct rows can be removed or modified.  It seems odd, but db_datawriter does not grant permission to select from database objects so, yes, the user must also either be a member of db_datareader or have specific SELECT permission on the objects to be modified

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question