Welcome to Lesson 8 of the SQL Server 2000 Tutorial. In this lesson we will cover adding roles. I hope you enjoy the lesson.

Adding Roles

Adding Roles
 

A database role is similar a group or virtual user.  Roles are assigned permissions in a database and then users are assigned to a role. Users inherit all the permissions associated with that role.  This makes database administration a lot simpler, since you do not have assign permission to individual users.

To create a database role, navigate to the database (Northwind) and click on the Roles icon.
As you noticed there are some predefined roles in the database already. 

Right-click on the Roles icon, select New Database Role.

We will call this new role, SQLnation.  We are presented here with two types of roles, a standard role and an application role.  We will choose standard role since we intend to add users to this role. Click the Add button to add users to our new role.

 

We will select the user jsmith, bgates, and sjobs to our new SQLnation role.  Click OK.

Click OK again to create the role. 

Now double-click on the SQLnation role to begin defining the permissions of this role.

Click on the Permissions button.

Clicking on the checkbox once will put a green check or grant permission.  Clicking the box again will put a red x or deny permission.  Clicking a third time will make the box neutral again or no explicit permission is given.

Click OK will save your permissions for the role.