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
- From the Start menu, point to Programs, then Microsoft SQL Server, and then click Enterprise Manager.
- Expand a server group, and then expand a server.
- Expand the databases group, and then expand a particular database.
- Right-click Roles, and click New Database Role.
- Enter a name for the role.
- If you wish to assign users to this role, select Add.
- 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