SQL Server 2005 Server-Level Fixed Roles
SQL Server 2005 Server-Level Fixed Roles
Fixed server roles are server-wide in their scope. Each member of a fixed server role can add other logins to that same role
The fixed server roles are:
* bulkadmin
* dbcreator
* diskadmin
* processadmin
* securityadmin
SQL Server Fixed Database-Level Roles
Fixed database roles are defined at the database level and exist in each database. Members of the db_owner and db_securityadmin database roles can manage fixed database role membership; however, only members of the db_owner database role can add members to the db_owner fixed database role.
The fixed database roles are the following:
* db_accessadmin
* db_backupoperator
* db_datareader
* db_datawriter
* db_ddladmin
For the full version of article please visit http://sqldbpool.blogspot.com/
