Does DB_DataWriter intrinsically have all the permissions of DB_DataReader?

• kamoskim

  SSC Enthusiast

  Points: 185

  More actions

  June 2, 2009 at 5:59 am

  #204963

  If one wants a user to have both "select access to all user tables and views" and "insert, update, delete access to all user tables and views", then must one put the user into both the DB_DataReader and the DB_DataWriter roles? Or, does DB_DataWriter intrinsically have all permissions that DB_DataReader has? Or, what?

• george sibbald

  SSC Guru

  Points: 104210

  More actions

  June 2, 2009 at 6:11 am

  #1003350

  a quick test shows db_datawriter does not have select permissions.

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