TABLE 2: Fixed Database Roles
ROLE PRIVILEGES
db_owner Has all permissions in the database
db_accessadmin Can add or remove user IDs
db_securityadmin Can manage all permissions, object ownerships, roles and role memberships
db_ddladmin Can issue ALL DDL, but cannot issue GRANT, REVOKE, or DENY statements
db_backupoperator Can issue DBCC, CHECKPOINT, and BACKUP statements
db_datawriter Can modify any data in any user table in the database
db_denydatareader Can not SELECT from any object in the database
db_denydatawriter Can not modify any data in the database