Roles Wizard (SQL Server)

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:
   • Properties panel - for details, see Roles (SQL Server) - Properties.
   • DDL View panel - for details, see Previewing the DDL Generated to Create the New Object.
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.