Purpose

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

To Add a Member to a SQL Server 2000 Database Role

A database user is a principal at the database level. Every database user is a member of the public role.

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

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

2. Now, expand Databases, then expand the database i.e. MyDatabase which contains the role, and click Roles.

3. In the details pane, right click the role to which you want to add a member i.e. db_accessadmin, and click Properties.

4. Now, click Add

5. Select a member from the list. i.e. andrew.

6. Click Apply, and then OK.