Creating Database Roles

To manage the permissions in your project database easily, it is recommended you define a set of roles based on job functions and assign each role the permissions that apply to that job. You create database roles with SQL Server Enterprise Manager.

To create a SQL Server 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 the databases group, and then expand a particular database.
4. Right-click Roles, and click New Database Role.
5. Enter a name for the role.
6. If you wish to assign users to this role, select Add.
7. Click OK.

Repeat these steps as required to create your 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 Workflow Application Users | Assigning Users to Database Roles | Defining Permissions for Database Roles