SQL Server 2005 introduces 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
Before SQL 2005, I've always had problems with non-sa users being able to see jobs they don't own. We couldn't even tell if someone else's job was running or not. Your DBA should be able to create a proxy account with one or more of these new SQLAgent roles enable. They are explained in detail in MSDN
at this link.
The above link provides the exact permissions associated with these new roles.
|
