Fixed database role membership Vs Database level permissions

• DBA Matt

  Right there with Babe

  Points: 742

  More actions

  May 10, 2012 at 9:31 am

  #256290

  Hi,

  I'm just doing some testing with database roles and database level permissions and was wondering what (if any) the differences are between:

  ~ the permissions obtained via membership of the fixed role db_datareader compared with permissions obtained via "GRANT SELECT TO [AUserOrRole]"

  ~ permissions obtained via membership of db_datawriter compared with database level "GRANT INSERT/UPDATE/DELETE"

  Thanks.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737236

  More actions

  May 10, 2012 at 10:03 am

  #1485819

  IIRC, there isn't a difference when you grant. If you add new objects, they are picked up by datareader/writer. Seems to also work in R2.