Microsoft SQL Server roles
Microsoft SQL Server roles Introduction Roles are the new SQL Server 7.0 feature, which was not available in the previous versions. SQL Server roles act like Windows NT local groups. Microsoft SQL Server supports several different types of roles. There are: server roles database roles application roles In this article, I want to tell you about each kind of roles, about how you can add new role, how you can drop existing role, how you can return information about the roles, and so on. Server Roles 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 The members of sysadmin server role can perform any activity in SQL Server and have completes control over all database fun...