Wednesday, October 6, 2010

SQL Server Agent jobs setup minimum permissions

SQL Server 2005 introduced the following msdb database fixed database roles, which give administrators finer control over access to SQL Server Agent. The roles listed from least to most privileged access are:
SQLAgentUserRole
SQLAgentReaderRole
SQLAgentOperatorRole


http://msdn.microsoft.com/en-us/library/ms188283.aspx

No comments:

Post a Comment