Wednesday, December 22, 2010

SQL Server Level Roles and Description








































Server Level RolesRights
BulkadminCan execute BULK INSERT statements
DbcreatorCreate, alter, and drop databases
DiskadminManage disk files
ProcessadminManage processes running in SQL Server
SecurityadminManage logins and CREATE DATABASE permissions, also read error logs and change passwords.
ServeradminSet server-wide configuration options, also shut down the server; alter endpoints
SetupadminManage linked servers and startup procedures
SysadminCan perform any activity in SQL Server

No comments:

Post a Comment