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 17.9.
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 ...