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 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 ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.