Server Roles Editor (SQL Server)

From DBArtisan
Jump to: navigation, search

Go Up to Microsoft SQL Server Object Editors

The Server Roles Editor lets you generate a set of sp_addsrvrolemember calls. This lets you change the login members of SQL Server’s fixed server roles: bulkadmin, dbcreator, diskadmin, processadmin, securityadmin, serveradmin, setupadmin, and sysadmin.

To edit the login members of a server role:

  1. Open an editor on the server role. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks

Logins

Select all check boxes associated with logins that are to be members of this server role.

DDL View

For details on using this tab, see Viewing the SQL/DDL for an Object.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.