6
Reply

What is a Server Role?

Ankur Jain

Ankur Jain

Aug 18, 2014
1.3k
0

    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

    Tusharika T
    December 23, 2014
    1

    SQL Server provides several roles for security

    Keerthi Venkatesan
    April 20, 2016
    0

    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

    Kml Surani
    May 13, 2015
    0

    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.

    Munesh Sharma
    February 14, 2015
    0

    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.

    Munesh Sharma
    October 09, 2014
    0

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

    Ankur Jain
    August 18, 2014
    0