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)


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

Post a Comment

Popular posts from this blog

SSIS2008R2 Error: 0xC0209303 at Package:

SQL2008R2 Error: The remote copy of database "XXXXX" has not been rolled forward to a point in time that is encompassed in the local copy of the database log. (Microsoft SQL Server, Error: 1412)