Creating Database Roles

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

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