Tag: SQL Server Level Roles

  • SQL Server Level Roles and Description

     

    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