Tuesday, May 29, 2012

Difference between database roles and server roles

S.No
Server Roles
Database Roles
1
It is defined at the server level.
It is defined at the database level.
2
It exists outside of user databases.
It exists in each database.
3
There are fixed server roles only.
User defined database roles available.
4
Bulkadmin,dbcreator,diskadmin,
processadmin,securityadmin,
serveradmin,setupadmin and sysadmin(8)
Db_accesadmin,db_backupoperator,
db_datareader,db_datawriter,
db_ddladmin,db_denydatareader,
db_denydatawriter,db_owner and db_securityadmin(9)


4 comments:

  1. Great list, thanks!

    Also a nice explanation right here:

    Database Roles

    ReplyDelete
  2. Great differentiation and with listing of either one. With Sql server 2012 onwards, there is possibility to user defined server role as well.

    ReplyDelete

MYSQL:::Seamless Data Archiving: Exporting, Importing, and Pruning MySQL Tables

  Seamless Data Archiving: Exporting, Importing, and Pruning MySQL Tables Introduction: In the dynamic landscape of database management...