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