<div>
That works really well....<br />
<br />
From a dba perspective do you think they would be happy with this setup?
</div>


That works really well....

From a dba perspective do you think they would be happy with this setup?

<div>
Sorry that sounded quite blunt. Appologies for that.
</div>


Sorry that sounded quite blunt. Appologies for that.

<div>
no problem... i'm just am SQL idot!!!
</div>


<div>
I just read on <a href="http://msdn.microsoft.com/en-us/library/ms188283.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/ms188283.aspx</a><br />
<br />
The SQLAgentReaderRole and the SQLAgentOperatorRole are automatically members of the SQLAgentUserRole. <br />
<br />
Should I deny permission on SQLAgentReaderRole and the SQLAgentOperatorRole as well?
</div>


I just read on http://msdn.microsoft.com/en-us/library/ms188283.aspx [http://msdn.microsoft.com/en-us/library/ms188283.aspx]

The SQLAgentReaderRole and the SQLAgentOperatorRole are automatically members of the SQLAgentUserRole.

Should I deny permission on SQLAgentReaderRole and the SQLAgentOperatorRole as well?

<div>
See what the DBA's say. If they arent bothered about then dont worry.
</div>


See what the DBA's say. If they arent bothered about then dont worry.

<div>
<div class="content wysiwyg-content">
Are there any security risks adding user to MSDB database and giving them permissions to execute agent jobs?
</div>
</div>


Are there any security risks adding user to MSDB database and giving them permissions to execute agent jobs?

Microsoft SQL Server 2005 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. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

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.