Creating
  Editing
  Deleting
  Querying
  Importing
  Exporting
  Properties
  Roles
  Creating
  Editing
  Deleting
  Querying
  Creating
  Editing
  Creating
  Editing
  Server Logins
DATABASE ROLES
Overview
Editing a Database Role

Overview

Roles are a powerful tool that allow you to collect users into a single unit against which you can apply permissions. Permissions granted to, denied to, or revoked from a role also apply to any members of the role. You can establish a role that represents a job performed by a class of workers in your organization and grant the appropriate permissions to that role. As workers rotate into the job, you simply add them as a member of the role; as they rotate out of the job, remove them from the role. You do not have to repeatedly grant, deny, and revoke permissions to or from each person as they accept or leave the job. The permissions are applied automatically when the users become members of the role.

Editing a Database Role

You may add or remove database users to or from a database role. System database roles consist of read only properties that you may not change. User defined database roles can not be created using this tool.