<div>
are you limited to assigning rights based upon SQL's predefined server roles, or can you create a server role and give specific rights?
</div>


are you limited to assigning rights based upon SQL's predefined server roles, or can you create a server role and give specific rights?

<div>
I discovered the feature in SQL 2012 of user defined server roles, so I am going to post this question under SQL 2012 and inquire about that new feature.
</div>


I discovered the feature in SQL 2012 of user defined server roles, so I am going to post this question under SQL 2012 and inquire about that new feature.

<div>
Agreed. Thank You. &nbsp;It's the next best thing to an answer.
</div>


Agreed. Thank You.  It's the next best thing to an answer.

<div>
<div class="content wysiwyg-content">
bulkadmin, dbcreator, iskadmin, processadmin, public, securityadmin, serveradmin, setupadmin, &nbsp;sysadmin.<br />
<br />
Above are the choices of Server roles. &nbsp;If a user needs to create jobs using SQL Server Agent-&gt;jobs and create maintenance plans using Management - &gt;&nbsp;maintenance plans, what would be the MINIMUM server role to give in order to perform those requirements?
</div>
</div>


bulkadmin, dbcreator, iskadmin, processadmin, public, securityadmin, serveradmin, setupadmin,  sysadmin.

Above are the choices of Server roles.  If a user needs to create jobs using SQL Server Agent->jobs and create maintenance plans using Management - > maintenance plans, what would be the MINIMUM server role to give in order to perform those requirements?

Minimum server role to meet needs

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.