Post reply

User security rights

  • June 10, 2012 at 2:31 am

    #270841

    Hi all,

    I was wondering, If i have a user with db_datareader rights and i upgrade them to db_datawriter would they still need reader? or does writer have those rights? and so on. for the rest would someone with owner need read write permissions? Id like to think not and that you need to tick reader writer for anyone who needs to search and update but wasnt sure when it comes to owner etc and BOL is a bit short on info.

  • June 10, 2012 at 11:28 am

    #1499103

    If you want the database user to be able to have SELECT permissions, then they will still need to be a member of the db_datareader role. db_datawriter is not a member of db_datareader.


    Twitter: @SQLife
    Email: sqlsalt(at)outlook(dot)com

  • June 11, 2012 at 3:21 am

    #1499211

    for the rest would someone with owner need read write permissions?

    No a member of database owner role will not need read and write permissions.

    =======================================================================================

    Visit my technical reference; you might find some of your issues already documented.

  • June 11, 2012 at 11:54 am

    #1499412

    thanks to you both..

    im bookmarked both you sites they look good 🙂

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

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