Microsoft® SQL Server 2008 R2 Unleashed

Using SSMS to Manage Database Roles

You can find database roles in the Object Explorer for each database, under the Security node, which contains a Roles node. The Roles node contains a Database Roles node, which lists both fixed and nonfixed database roles. To add a new custom database role (nonfixed), you right-click the Database Roles node and select New Database Role. A new database role dialog box appears, as shown in Figure 11.9.

Figure 11.9 The new database role dialog box.

You need to enter a name for the role and name for the owner of the role. Like a database user, a database role can also own schemas. If you click the Add button, you ...