Ankur Jain
What is a Server Role?
By Ankur Jain in Databases & DBA on Aug 18 2014
  • Tusharika T
    Dec, 2014 23

    Server roles are defined at the server level and exist outside of users databases. There are only fixed server roles, so you cannot add, delete or modify server role. You can only add users as a member of the server roles.There are seven fixed server roles:sysadmin serveradmin setupadmin securityadmin processadmin dbcreator diskadmin

    • 1
  • Keerthi Venkatesan
    Apr, 2016 20

    SQL Server provides several roles for security

    • 0
  • Kml Surani
    May, 2015 13

    Members of the securityadmin fixed server role manage logins and their properties. They can GRANT, DENY, and REVOKE server-level permissions. They can also GRANT, DENY, and REVOKE database-level permissions if they have access to a database. Additionally, they can reset passwords for SQL Server logins

    • 0
  • Munesh Sharma
    Feb, 2015 14

    A server role is a set of software programs that, when they are installed and properly configured, lets a computer perform a specific function for multiple users or other computers within a network. Generally, roles share the following characteristics. They describe the primary function, purpose, or use of a computer.

    • 0
  • Munesh Sharma
    Oct, 2014 9

    A server role is a set of software programs that, when they are installed and properly configured, lets a computer perform a specific function for multiple users or other computers within a network. Generally, roles share the following characteristics. They describe the primary function, purpose, or use of a computer.

    • 0
  • Ankur Jain
    Aug, 2014 18

    A server role is pre-defined by SQL Server. It possesses a pre-defined set of rights.

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS