| Server Level Roles | Rights |
| Bulkadmin | Can execute BULK INSERT statements |
| Dbcreator | Create, alter, and drop databases |
| Diskadmin | Manage disk files |
| Processadmin | Manage processes running in SQL Server |
| Securityadmin | Manage logins and CREATE DATABASE permissions, also read error logs and change passwords. |
| Serveradmin | Set server-wide configuration options, also shut down the server; alter endpoints |
| Setupadmin | Manage linked servers and startup procedures |
| Sysadmin | Can perform any activity in SQL Server |
Showing posts with label SQL Server Level Roles. Show all posts
Showing posts with label SQL Server Level Roles. Show all posts
Wednesday, December 22, 2010
SQL Server Level Roles and Description
Subscribe to:
Posts (Atom)