Roles in SQL Server

Predefined database roles:

• db_owner: Members have full access.
• db_accessadmin: Members can manage Windows groups and SQL Server logins.
• db_datareader: Members can read all data.
• db_datawriter: Members can add, delete, or modify data in tables.
• db_ddladmin: Members can run dynamic-link library(DLL) statements.
• db_securityadmin: Members can modify role membership and manage permissions.
• db_backupoperator: Members can backup the databases.
• db_denydatareader: Members can't view data within the datase.
• db_denydatawriter: Members can't change or delete data in tables or views.

 

Fixed Roles:

• SysAdmin: Any member can perform any action on the server.
• ServerAdmin: Any member can set configuration options on the server.
• SetupAdmin: Any member can manage linked servers and SQL Server startup options and tasks.
• SecurityAdmin: Any member can manage server security.
• ProcessAdmin: Any member can kill processes running on SQL Server.
• DbCreator: Any member can create, alter, drop, and restore databases.
• DiskAdmin: Any member can manage SQL Server disk files.
• BulkAdmin: Any Member can run the bulk insert command.