Thursday, 5 March 2015

Server roles

Role is a collection of privileges.  

There are 8 server roles in sql server they are as follows.
  1. Sysadmin
  2. Server admin
  3. Setup admin
  4. DB creator
  5. Disk admin
  6. Bulk admin
  7. Process admin
  8. Security admin
Sysadmin:  The members of this role can perform any operation on the server. This is the root level entry on the server.
Posted by at

1 comment:

Subscribe to: Post Comments (Atom)