Using SSMS to Manage Server Roles
You can find server roles in the Object Explorer under the Security
node, which contains a Server Roles
node. The Server Roles
node lists both fixed and nonfixed server roles. To add a new custom server role (nonfixed), you right-click the Server Roles
node and select New Server Role. A new Server Role dialog box appears, as shown in Figure 15.10.
You need to enter a name for the role and name for the owner of the role. In Figure 15.10 the new server role name has been set to DbCreatorOnly
. A specific server instance has been selected as well, which causes the Permissions ...
Get Microsoft SQL Server 2014 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.