I'm on SQL SERVER 2008,
I want to enable the SQL Agent for a particular user, who has only read access to the database. I don't want to give sysadmin role?
Is there any way, I can do this?
I'm on SQL SERVER 2008,
I want to enable the SQL Agent for a particular user, who has only read access to the database. I don't want to give sysadmin role?
Is there any way, I can do this?
from BOL :
To configure a user to create or execute Microsoft SQL Server Agent jobs, you must first add an existing SQL Server login or msdb role to one of the following SQL Server Agent fixed database roles in the msdb database: SQLAgentUserRole, SQLAgentReaderRole, or SQLAgentOperatorRole.