Assigning Users to Database Roles

When you add a new user account to your database or you must change the permissions of an existing user, you can add the user to a workflow application database role rather than applying permissions directly to the account.

To assign a user to a database role

1. From the Start menu, point to Programs, then Microsoft SQL Server, and then click Enterprise Manager.

2. Expand a server group, and then expand a server.

3. Expand Databases, and then expand the database in which the role exists.

4. Click Roles.

5. In the details pane, right-click the role to which you want to add the user, and select Properties.

6. Click Add. Then, click a user or users to add. Only users in the current database can be added to the role.

   Note   When you add a Microsoft® Windows® 2000 login that does not have a user account in the database to a Microsoft® SQL Server™ database role, SQL Server creates a user account in the database automatically.

7. Click OK to close the Add Role Members dialog box.

8. Click OK to close the Database Role Properties dialog box.

Repeat these steps as required to add users to other database roles.

See Also

Setting Up Accounts, Logins, Roles, and Users | Security Categories in Workflow Designer for SQL Server | Windows 2000 and SQL Server Security | Creating Database Roles | Creating Workflow Application Users | Defining Permissions for Database Roles