Purpose

The purpose of this article is to teach you the process of creating a SQL Server 2000 database role.

To Create a SQL Server 2000 Database Role

Database 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. The permissions are applied automatically when the users become members of the role.

Following steps describe you the step by step details of creating a SQL Server 2000 database role:

1. Click Start, go to Programs, then go to Microsoft SQL Server, and click Enterprise Manager.

2. Expand Databases, then expand the database for which database role is to be created.

3. Now, right click Roles, and click New Database Role.

4. Give name to database role in Name field.

5. Click Add button.

6. Click OK.

7. Click OK.