Sql Cert - Roles

Front 1

Server Level Role - sysadmin

Back 1

Members of the sysadmin fixed server role can perform any activity in the server. Only members of this role can create and modify maintenance plans

Front 2

Server Level Role - serveradmin

Back 2

can change server-wide configuration options and shut down the server

Front 3

Server Level Role - securityadmin

Back 3

Manage logins and their properties. They can GRANT, DENY, and REVOKE server level permissions. They can also GRANT, DENY, and REVOKE db level permissions if they have access to a db. They can reset passwords for SQL server logins. equivalent to the sysadmin role.

Front 4

Server Level Role - processadmin

Back 4

can end processes that are running in an instance of SQL Server

Front 5

Server Level Role - setupadmin

Back 5

remove linked servers

Front 6

Server Level Role - bulkadmin

Back 6

can run the BULK INSERT statement

Front 7

Server Level Role - diskadmin

Back 7

is used for managing disk files

Front 8

Server Level Role - dbcreator

Back 8

can create, alter, drop and restore any db

Front 9

Server Level Role - Public

Back 9

default role