Help   Logout  
 
 
  Creating
  Editing
  Deleting
  Querying
  Importing
  Exporting
  Properties
  Roles
  Creating
  Editing
  Deleting
  Querying
  Creating
  Editing
  Creating
  Editing
  Server Logins
SERVER ROLES
Overview
Editing a SQL Server Role

Overview

The security mechanism in Microsoft® SQL Server™ includes several predefined roles with implied permissions that cannot be granted to other user accounts. If you have users who require these permissions, you must add their accounts to these predefined roles. The two types of predefined roles are fixed server and fixed database.

Editing a SQL Server Role

SQL Server roles have predefined permissions that can not be changed. You may add or remove logins from a role by clicking on Add or Edit Logins.