| 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 |
Wednesday, December 22, 2010
SQL Server Level Roles and Description
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment