Read access and permissions

Posted on 2009-12-15
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
    LVL 7

    Accepted Solution

    no db_datareader and db_datawrite is sufficient.
    LVL 5

    Assisted Solution

    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

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    Suggested Solutions

    INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
    PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    755 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

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now