A role to...

• Mithrandir

  SSCrazy

  Points: 2628

  More actions

  June 20, 2006 at 4:49 pm

  #173069

  Hello guys.

  I'm looking for a role(s)/permission(s) wich allow me to access (read/write) every DB on the server, but don't allow the user change any security setting.

  This can be done? So far I've reviewed the server roles and only sysadmin allow to move trough every DB of the server.

  Thanks

• Jim Dillon-291542

  Hall of Fame

  Points: 3344

  More actions

  June 22, 2006 at 7:49 am

  #645245

  I don't know of a server role that would provide the type of permissions you are requesting, but you can use database roles.

  Select the db_datareader and db_datawriter database roles.

  Which will give the user read and write permissions to the specified database.