Roles Wizard (SQL Server)

From DBArtisan
Jump to: navigation, search

Go Up to Microsoft SQL Server Object Wizards

Roles are sets of user privileges you associate with access to objects within a database. Roles streamline the process of granting permissions. You can use roles to grant sets of permissions and privileges to users and groups. Roles can help you comply with Sarbanes Oxley regulations by limiting which users can have access to what privileges, for example a Human Resources Role versus an Accounting Role.

To create a new role using a wizard:

  1. Open a creation wizard for a role. For details, see Opening an Object Wizard.
  2. Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
  3. Finally, use the Execute button to create the object.

After you click Finish and the role has been created, the Roles Editor open. You can then assign object and system privileges to the role and determine which users can take part in the role. For more information, see Roles Editor (SQL Server).

Roles (SQL Server) - Properties

When creating or editing a role, this tab/panel lets you work with the following settings:

Setting Description

Name

The name used to reference the role.

RoleType

The value can be NONE, APPLICATION, or STANDARD.

Authorization Owner

Only required with a Role Type of STANDARD.

Password

Only required with a Role Type of APPLICATION.