Server Roles Editor (SQL Server)
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:
- Open an editor on the server role. For details, see Opening an Object Editor.
- 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.